diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2023-07-09 09:46:24 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2023-07-09 09:48:16 +0200 |
| commit | be2ab58f6227ef8ea341c3d9b9f99d53d56529a9 (patch) | |
| tree | 3724122e81bbf47cac1cb1cd36fedd2873d02e70 | |
| parent | f8d03ea727e48c894174c4e5e6ebafc3a17ab3f7 (diff) | |
| download | postgresql-be2ab58f6227ef8ea341c3d9b9f99d53d56529a9.tar.gz postgresql-be2ab58f6227ef8ea341c3d9b9f99d53d56529a9.zip | |
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.
| -rw-r--r-- | doc/src/sgml/ref/copy.sgml | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 5e591ed2e63..4d614a0225d 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -36,6 +36,7 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable FREEZE [ <replaceable class="parameter">boolean</replaceable> ] DELIMITER '<replaceable class="parameter">delimiter_character</replaceable>' NULL '<replaceable class="parameter">null_string</replaceable>' + DEFAULT '<replaceable class="parameter">default_string</replaceable>' HEADER [ <replaceable class="parameter">boolean</replaceable> | MATCH ] QUOTE '<replaceable class="parameter">quote_character</replaceable>' ESCAPE '<replaceable class="parameter">escape_character</replaceable>' @@ -43,7 +44,6 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable FORCE_NOT_NULL ( <replaceable class="parameter">column_name</replaceable> [, ...] ) FORCE_NULL ( <replaceable class="parameter">column_name</replaceable> [, ...] ) ENCODING '<replaceable class="parameter">encoding_name</replaceable>' - DEFAULT '<replaceable class="parameter">default_string</replaceable>' </synopsis> </refsynopsisdiv> @@ -272,6 +272,19 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable </varlistentry> <varlistentry> + <term><literal>DEFAULT</literal></term> + <listitem> + <para> + Specifies the string that represents a default value. Each time the string + is found in the input file, the default value of the corresponding column + will be used. + This option is allowed only in <command>COPY FROM</command>, and only when + not using <literal>binary</literal> format. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>HEADER</literal></term> <listitem> <para> @@ -370,19 +383,6 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable </varlistentry> <varlistentry> - <term><literal>DEFAULT</literal></term> - <listitem> - <para> - Specifies the string that represents a default value. Each time the string - is found in the input file, the default value of the corresponding column - will be used. - This option is allowed only in <command>COPY FROM</command>, and only when - not using <literal>binary</literal> format. - </para> - </listitem> - </varlistentry> - - <varlistentry> <term><literal>WHERE</literal></term> <listitem> <para> |