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 | 96aa9b60896def1e6c2a1dd127498e58c53361cf (patch) | |
| tree | 57a8e815b9fea1e909d3ae8b2e2ca0de3ca84efd | |
| parent | e8f60e6fe206b4877c5b0d0b70015e672de04f60 (diff) | |
| download | postgresql-96aa9b60896def1e6c2a1dd127498e58c53361cf.tar.gz postgresql-96aa9b60896def1e6c2a1dd127498e58c53361cf.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
| -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 3e6f9cd5324..5e842f9cd73 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> |