diff options
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/copy.sgml | 25 |
1 files changed, 23 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 6c83e30ed09..33ce7c4ea6c 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -45,6 +45,7 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable FORCE_NULL { ( <replaceable class="parameter">column_name</replaceable> [, ...] ) | * } ON_ERROR '<replaceable class="parameter">error_action</replaceable>' ENCODING '<replaceable class="parameter">encoding_name</replaceable>' + LOG_VERBOSITY <replaceable class="parameter">mode</replaceable> </synopsis> </refsynopsisdiv> @@ -400,8 +401,12 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable when the <literal>FORMAT</literal> is <literal>text</literal> or <literal>csv</literal>. </para> <para> - A <literal>NOTICE</literal> message containing the ignored row count is emitted at the end - of the <command>COPY FROM</command> if at least one row was discarded. + A <literal>NOTICE</literal> message containing the ignored row count is + emitted at the end of the <command>COPY FROM</command> if at least one + row was discarded. When <literal>LOG_VERBOSITY</literal> option is set to + <literal>verbose</literal>, a <literal>NOTICE</literal> message + containing the line of the input file and the column name whose input + conversion has failed is emitted for each discarded row. </para> </listitem> </varlistentry> @@ -419,6 +424,22 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable </varlistentry> <varlistentry> + <term><literal>LOG_VERBOSITY</literal></term> + <listitem> + <para> + Specify the amount of messages emitted by a <command>COPY</command> + command: <literal>default</literal> or <literal>verbose</literal>. If + <literal>verbose</literal> is specified, additional messages are emitted + during processing. + </para> + <para> + This is currently used in <command>COPY FROM</command> command when + <literal>ON_ERROR</literal> option is set to <literal>ignore</literal>. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>WHERE</literal></term> <listitem> <para> |