diff options
| author | Michael Paquier <michael@paquier.xyz> | 2020-07-18 10:42:50 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2020-07-18 10:42:50 +0900 |
| commit | aee67299306e717986f054d149f6cb2f1c447656 (patch) | |
| tree | c0640963be5ed068945bbdee96c28d75d5ca8d75 | |
| parent | 66232220ee6e35aefd9abfb9a551db142c1604d8 (diff) | |
doc: Fix description of \copy for psql
The WHERE clause introduced by 31f3817 was not described. While on it,
split the grammar of \copy FROM and TO into two distinct parts for
clarity as they support different set of options.
Author: Vignesh C
Discussion: https://postgr.es/m/CALDaNm3zWr=OmxeNqOqfT=uZTSdam_j-gkX94CL8eTNfgUtf6A@mail.gmail.com
Backpatch-through: 12
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index cfd0918751f..b0335b9592b 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -983,9 +983,15 @@ testdb=> </varlistentry> <varlistentry id="app-psql-meta-commands-copy"> + <term><literal>\copy { <replaceable class="parameter">table</replaceable> [ ( <replaceable class="parameter">column_list</replaceable> ) ] } + <literal>from</literal> + { <replaceable class="parameter">'filename'</replaceable> | program <replaceable class="parameter">'command'</replaceable> | stdin | pstdin } + [ [ with ] ( <replaceable class="parameter">option</replaceable> [, ...] ) ] + [ where <replaceable class="parameter">condition</replaceable> ]</literal></term> + <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> | program <replaceable class="parameter">'command'</replaceable> | stdin | stdout | pstdin | pstdout } + <literal>to</literal> + { <replaceable class="parameter">'filename'</replaceable> | program <replaceable class="parameter">'command'</replaceable> | stdout | pstdout } [ [ with ] ( <replaceable class="parameter">option</replaceable> [, ...] ) ]</literal></term> <listitem> |