| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | hvrauhal(at)gmail(dot)com |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: The options to COPY statement can not be separated with a comma |
| Date: | 2016-11-25 22:51:00 |
| Message-ID: | 20161125225100.xoa25ehbranosunk@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
hvrauhal(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2016-11-27 16:12:34 | Re: Documentation does not SSL parameters are postmaster-only |
| Previous Message | hvrauhal | 2016-11-25 11:28:13 | The options to COPY statement can not be separated with a comma |