On Thursday, December 19, 2019, Tom Lane <t...@sss.pgh.pa.us> wrote: > "David G. Johnston" <david.g.johns...@gmail.com> writes: > > Seems better to simply talk about each form independently: > > > If a list of columns is specified, <command>COPY TO</command> will only > > copy the data in the specified columns to the file. <command>COPY > > FROM</command> will, by position (i.e., the number of columns listed must > > match the number of columns in the file), match each file column to the > > named column in the table. Any additional columns present in the table > > will receive their default value. > > +1 for separating it like that, but your middle sentence reads awkwardly > to me. How about something like > > <command>COPY FROM</command> will match each listed column in the table > to a file column by position (so the number of columns listed must match > the number of columns in the file). > > >
+1 David J.
