Skip to content

Commit dda589c

Browse files
committed
Update syntax shown for \copy to match new syntax for COPY.
Etsuro Fujita
1 parent 0a1967a commit dda589c

File tree

1 file changed

+6
-13
lines changed

1 file changed

+6
-13
lines changed

doc/src/sgml/ref/psql-ref.sgml

+6-13
Original file line numberDiff line numberDiff line change
@@ -830,18 +830,7 @@ testdb=>
830830
<term><literal>\copy { <replaceable class="parameter">table</replaceable> [ ( <replaceable class="parameter">column_list</replaceable> ) ] | ( <replaceable class="parameter">query</replaceable> ) }
831831
{ <literal>from</literal> | <literal>to</literal> }
832832
{ <replaceable class="parameter">filename</replaceable> | stdin | stdout | pstdin | pstdout }
833-
[ with ]
834-
[ binary ]
835-
[ oids ]
836-
[ delimiter [ as ] '<replaceable class="parameter">character</replaceable>' ]
837-
[ null [ as ] '<replaceable class="parameter">string</replaceable>' ]
838-
[ csv
839-
[ header ]
840-
[ quote [ as ] '<replaceable class="parameter">character</replaceable>' ]
841-
[ escape [ as ] '<replaceable class="parameter">character</replaceable>' ]
842-
[ force quote <replaceable class="parameter">column_list</replaceable> | * ]
843-
[ force not null <replaceable class="parameter">column_list</replaceable> ] ]</literal>
844-
</term>
833+
[ [ with ] ( <replaceable class="parameter">option</replaceable> [, ...] ) ]</literal></term>
845834

846835
<listitem>
847836
<para>
@@ -859,7 +848,11 @@ testdb=&gt;
859848
<para>
860849
The syntax of the command is similar to that of the
861850
<acronym>SQL</acronym> <xref linkend="sql-copy">
862-
command. Note that, because of this,
851+
command, and
852+
<replaceable class="parameter">option</replaceable>
853+
must indicate one of the options of the
854+
<acronym>SQL</acronym> <xref linkend="sql-copy"> command.
855+
Note that, because of this,
863856
special parsing rules apply to the <command>\copy</command>
864857
command. In particular, the variable substitution rules and
865858
backslash escapes do not apply.

0 commit comments

Comments
 (0)