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 | 4cab43ec806a6298a545a399415ee8c4fe9307a8 (patch) | |
| tree | e17dab4e6e04dfe5148159440697f4157247130b /doc/src | |
| parent | 0af0504da91e5e15f0b203309a1e49a4829dac64 (diff) | |
| download | postgresql-4cab43ec806a6298a545a399415ee8c4fe9307a8.tar.gz postgresql-4cab43ec806a6298a545a399415ee8c4fe9307a8.zip | |
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
Diffstat (limited to 'doc/src')
| -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 d9b7c4d0d48..a99f8155e46 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> |