Skip to content

Commit be2ab58

Browse files
committed
doc: Move DEFAULT parameter on COPY reference page
The DEFAULT parameter seems most similar to the NULL parameter, so move it next to it, instead of having it at the end of the parameter list because it was the last one added.
1 parent f8d03ea commit be2ab58

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)