diff options
| author | Bruce Momjian <bruce@momjian.us> | 2019-12-21 12:44:38 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2019-12-21 12:44:38 -0500 |
| commit | 586f4ffd6de3be0f0566d23a2deeb2628b9f036e (patch) | |
| tree | a4854ebb17be22837e84a22003d2bbe808b266fe | |
| parent | c11bd6c10fe56b627a5ecb3263bbbcde60a06091 (diff) | |
docs: clarify handling of column lists in COPY TO/FROM
Previously it was unclear how COPY FROM handled cases where not all
columns were specified, or if the order didn't match.
Reported-by: pavlo.golub@gmail.com
Discussion: https://postgr.es/m/157487729344.7213.14245726713444755296@wrigleys.postgresql.org
Backpatch-through: 9.4
| -rw-r--r-- | doc/src/sgml/ref/copy.sgml | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 8f1435db476..62f4b6ee790 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -61,11 +61,11 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable </para> <para> - If a list of columns is specified, <command>COPY</command> will - only copy the data in the specified columns to or from the file. - If there are any columns in the table that are not in the column list, - <command>COPY FROM</command> will insert the default values for - those columns. + If a column list is specified, <command>COPY TO</command> copies only + the data in the specified columns to the file. For <command>COPY + FROM</command>, each field in the file is inserted, in order, into the + specified column. Table columns not specified in the <command>COPY + FROM</command> column list will receive their default values. </para> <para> |