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

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

From
hvrauhal@gmail.com
Date:
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

From
Alvaro Herrera
Date:
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