The options to COPY statement can not be separated with a comma

Поиск
Список
Период
Сортировка
Искать

The options to COPY statement can not be separated with a comma

От:
hvrauhal@gmail.com
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/sql-copy.html
Description:

The documentation describes: 
 [ [ WITH ] ( option [, ...] ) ]

But actually the options are only separated by spaces, for example 
`with CSV HEADER NULL '';`

Re: The options to COPY statement can not be separated with a comma

От:
Alvaro Herrera <alvherre@2ndquadrant.com>
Дата:
hvrauhal@gmail.com wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/9.5/static/sql-copy.html
> Description:
> 
> The documentation describes: 
>  [ [ WITH ] ( option [, ...] ) ]
> 
> But actually the options are only separated by spaces, for example 
> `with CSV HEADER NULL '';`

The documentation describes new-style options, which are enclosed by
parens and separated by commas.  Old-style (pre-9.0) did not have the
comma separators nor parens; those are still supported but should not be
used by new applications.  See "Compatibility" at the bottom of the
page.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
FAQ