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 | 075129276ed66c9ac19198ec8aa108a538086d82 (patch) | |
| tree | 25fb9283094a001e732e4f09c0d26ba64c58265d | |
| parent | d09cfa3e2874fb5ca5db046bff574d77e335049a (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 bdc4ae6da9e..564a48f246e 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> |