Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitbe2ab58

Browse files
committed
doc: Move DEFAULT parameter on COPY reference page
The DEFAULT parameter seems most similar to the NULL parameter, somove it next to it, instead of having it at the end of the parameterlist because it was the last one added.
1 parentf8d03ea commitbe2ab58

File tree

1 file changed

+14
-14
lines changed

1 file changed

+14
-14
lines changed

‎doc/src/sgml/ref/copy.sgml

Lines changed: 14 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -36,14 +36,14 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable
3636
FREEZE [ <replaceable class="parameter">boolean</replaceable> ]
3737
DELIMITER '<replaceable class="parameter">delimiter_character</replaceable>'
3838
NULL '<replaceable class="parameter">null_string</replaceable>'
39+
DEFAULT '<replaceable class="parameter">default_string</replaceable>'
3940
HEADER [ <replaceable class="parameter">boolean</replaceable> | MATCH ]
4041
QUOTE '<replaceable class="parameter">quote_character</replaceable>'
4142
ESCAPE '<replaceable class="parameter">escape_character</replaceable>'
4243
FORCE_QUOTE { ( <replaceable class="parameter">column_name</replaceable> [, ...] ) | * }
4344
FORCE_NOT_NULL ( <replaceable class="parameter">column_name</replaceable> [, ...] )
4445
FORCE_NULL ( <replaceable class="parameter">column_name</replaceable> [, ...] )
4546
ENCODING '<replaceable class="parameter">encoding_name</replaceable>'
46-
DEFAULT '<replaceable class="parameter">default_string</replaceable>'
4747
</synopsis>
4848
</refsynopsisdiv>
4949

@@ -271,6 +271,19 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable
271271
</listitem>
272272
</varlistentry>
273273

274+
<varlistentry>
275+
<term><literal>DEFAULT</literal></term>
276+
<listitem>
277+
<para>
278+
Specifies the string that represents a default value. Each time the string
279+
is found in the input file, the default value of the corresponding column
280+
will be used.
281+
This option is allowed only in <command>COPY FROM</command>, and only when
282+
not using <literal>binary</literal> format.
283+
</para>
284+
</listitem>
285+
</varlistentry>
286+
274287
<varlistentry>
275288
<term><literal>HEADER</literal></term>
276289
<listitem>
@@ -369,19 +382,6 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable
369382
</listitem>
370383
</varlistentry>
371384

372-
<varlistentry>
373-
<term><literal>DEFAULT</literal></term>
374-
<listitem>
375-
<para>
376-
Specifies the string that represents a default value. Each time the string
377-
is found in the input file, the default value of the corresponding column
378-
will be used.
379-
This option is allowed only in <command>COPY FROM</command>, and only when
380-
not using <literal>binary</literal> format.
381-
</para>
382-
</listitem>
383-
</varlistentry>
384-
385385
<varlistentry>
386386
<term><literal>WHERE</literal></term>
387387
<listitem>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp