| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | neilbower(at)gmail(dot)com |
| Subject: | SQL Commands COPY |
| Date: | 2021-06-09 19:54:54 |
| Message-ID: | 162326849405.14468.13255406860802922380@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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 the example in the compatibility section shows the option name
as FORCE QUOTE (no underscore) and has no requirement to enclose the column
names with round brackets.
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 throw a syntax
error.
My usage is
COPY (query)
TO STDOUT
CSV HEADER
DELIMITER E'\t'
NULL ''
QUOTE '"'
FORCE QUOTE column_name [, ...]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-06-09 21:31:18 | Re: SQL Commands COPY |
| Previous Message | Tom Lane | 2021-06-08 16:43:37 | Re: functions-matching.html: Tip says use "Per or Tcl ... ? |