diff options
| author | Robert Haas <rhaas@postgresql.org> | 2012-09-06 17:00:03 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2012-09-06 17:00:03 -0400 |
| commit | dda589c96b89320446933108ca946e7e6b8eb9d2 (patch) | |
| tree | 827eea539efa61b314eb36e80c3720578ba7a836 /doc/src | |
| parent | 0a1967a0ef01cd193d9aa212dcf54a1b1d56720e (diff) | |
| download | postgresql-dda589c96b89320446933108ca946e7e6b8eb9d2.tar.gz postgresql-dda589c96b89320446933108ca946e7e6b8eb9d2.zip | |
Update syntax shown for \copy to match new syntax for COPY.
Etsuro Fujita
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 19 |
1 files changed, 6 insertions, 13 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 0675a8e17b1..c41593c5e36 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -830,18 +830,7 @@ testdb=> <term><literal>\copy { <replaceable class="parameter">table</replaceable> [ ( <replaceable class="parameter">column_list</replaceable> ) ] | ( <replaceable class="parameter">query</replaceable> ) } { <literal>from</literal> | <literal>to</literal> } { <replaceable class="parameter">filename</replaceable> | stdin | stdout | pstdin | pstdout } - [ with ] - [ binary ] - [ oids ] - [ delimiter [ as ] '<replaceable class="parameter">character</replaceable>' ] - [ null [ as ] '<replaceable class="parameter">string</replaceable>' ] - [ csv - [ header ] - [ quote [ as ] '<replaceable class="parameter">character</replaceable>' ] - [ escape [ as ] '<replaceable class="parameter">character</replaceable>' ] - [ force quote <replaceable class="parameter">column_list</replaceable> | * ] - [ force not null <replaceable class="parameter">column_list</replaceable> ] ]</literal> - </term> + [ [ with ] ( <replaceable class="parameter">option</replaceable> [, ...] ) ]</literal></term> <listitem> <para> @@ -859,7 +848,11 @@ testdb=> <para> The syntax of the command is similar to that of the <acronym>SQL</acronym> <xref linkend="sql-copy"> - command. Note that, because of this, + command, and + <replaceable class="parameter">option</replaceable> + must indicate one of the options of the + <acronym>SQL</acronym> <xref linkend="sql-copy"> command. + Note that, because of this, special parsing rules apply to the <command>\copy</command> command. In particular, the variable substitution rules and backslash escapes do not apply. |