Re: SQL Commands COPY

2021-06-11 Thread Neil Bower
It was a picnic. I was confusing the 9+ version syntax with the pre-9 version syntax at the bottom of the page. Most of the options between the two versions are the same and the pre-9 version still works with the newer versions of PostgreSQL. I was connecting to a version 13 server at the time. I'

Re: SQL Commands COPY

2021-06-09 Thread Tom Lane
Laurenz Albe writes: > On Wed, 2021-06-09 at 19:54 +, PG Doc comments form wrote: >> When using psql (version 13.3) against a version 13 cluster, the method >> shown in the compatibility section works whereas the methods shown in the >> synopsis and parameters sections do not work and will thr

Re: SQL Commands COPY

2021-06-09 Thread Laurenz Albe
On Wed, 2021-06-09 at 19:54 +, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/13/sql-copy.html > Description: > > The synopsis and parameters for the COPY command show the FORCE_QUOTE option > with an underscore and requires column names to be enclosed with round > bracket

SQL Commands COPY

2021-06-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-copy.html Description: The synopsis and parameters for the COPY command show the FORCE_QUOTE option with an underscore and requires column names to be enclosed with round brackets, but