SQL Commands COPY

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема SQL Commands COPY
Дата
Msg-id 162326849405.14468.13255406860802922380@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: SQL Commands COPY  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: functions-matching.html: Tip says use "Per or Tcl ... ?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: SQL Commands COPY