SQL Commands COPY - Mailing list pgsql-docs

From PG Doc comments form
Subject SQL Commands COPY
Date
Msg-id 162326849405.14468.13255406860802922380@wrigleys.postgresql.org
Whole thread Raw
Responses Re: SQL Commands COPY  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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 [, ...]

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: functions-matching.html: Tip says use "Per or Tcl ... ?
Next
From: Laurenz Albe
Date:
Subject: Re: SQL Commands COPY