pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: hvrauhal@gmail.com
Cc: pgsql-docs@postgresql.org
Subject: Re: The options to COPY statement can not be separated with a comma
Date: Fri, 25 Nov 2016 19:51:00 -0300
Message-ID: <20161125225100.xoa25ehbranosunk@alvherre.pgsql> (raw)
In-Reply-To: <20161125112813.6539.29538@wrigleys.postgresql.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>

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 &#39;&#39;;`

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


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs



view thread (2+ messages)

Message-ID: <20161125225100.xoa25ehbranosunk@alvherre.pgsql>
Permalink:  ../20161125225100.xoa25ehbranosunk@alvherre.pgsql/
Also on:    postgresql.org/message-id/20161125225100.xoa25ehbranosunk@alvherre.pgsql

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: alvherre@2ndquadrant.com, hvrauhal@gmail.com
  Subject: Re: The options to COPY statement can not be separated with a comma
  In-Reply-To: <20161125225100.xoa25ehbranosunk@alvherre.pgsql>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox