MIME-Version: 1.0
References: <162326849405.14468.13255406860802922380@wrigleys.postgresql.org>
 <a1357b1d4e6868d8cce4c484b06cd68239543403.camel@cybertec.at>
 <1510077.1623275238@sss.pgh.pa.us>
In-Reply-To: <1510077.1623275238@sss.pgh.pa.us>
From: Neil Bower <neilbower@gmail.com>
Date: Fri, 11 Jun 2021 13:16:29 -0600
Message-ID: 
 <CAKEGPH-A-mkjdfq17z3Nia+b=QOa0aUPdDQjcU6Fq-SkpRjSMw@mail.gmail.com>
Subject: Re: SQL Commands COPY
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e9b1fa05c482581b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKEGPH-A-mkjdfq17z3Nia%2Bb%3DQOa0aUPdDQjcU6Fq-SkpRjSMw%40mail.gmail.com>
Precedence: bulk

--000000000000e9b1fa05c482581b
Content-Type: text/plain; charset="UTF-8"

It was a picnic. I was confusing the 9+ version syntax with the pre-9
version syntax at the bottom of the page. Most of the options between the
two versions are the same and the pre-9 version still works with the newer
versions of PostgreSQL.

I was connecting to a version 13 server at the time. I've been using this
same syntax for several years and never noticed the one key difference
between the older and newer versions of the syntax of having to enclose the
options within round brackets until Laurenz's example.

Thanks!

On Wed, 9 Jun 2021 at 15:47, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Laurenz Albe <laurenz.albe@cybertec.at> writes:
> > On Wed, 2021-06-09 at 19:54 +0000, PG Doc comments form wrote:
> >> 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.
>
> > You must be misreading something, the new syntax works:
> > COPY (SELECT 42 AS x) TO STDOUT (FORMAT 'csv', FORCE_QUOTE (x));
>
> The most probable explanation seems to be that the OP is actually
> connecting to an 8.4 (or older) PG server.
>
>                         regards, tom lane
>

--000000000000e9b1fa05c482581b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">It was a picnic. I was confusing the 9+ v=
ersion syntax with the pre-9 version syntax at the bottom of the page. Most=
 of the options between the two versions are the same and the pre-9 version=
 still works with the newer versions of PostgreSQL.<div><br></div><div>I wa=
s connecting to a version 13 server at the time. I&#39;ve been using this s=
ame syntax for several years and never noticed the one key difference betwe=
en the older and newer versions of the syntax of having to enclose the opti=
ons within round brackets until Laurenz&#39;s example.=C2=A0</div><div><br>=
</div><div>Thanks!</div></div><br><div class=3D"gmail_quote"><div dir=3D"lt=
r" class=3D"gmail_attr">On Wed, 9 Jun 2021 at 15:47, Tom Lane &lt;<a href=
=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex">Laurenz Albe &lt;<a href=3D"=
mailto:laurenz.albe@cybertec.at" target=3D"_blank">laurenz.albe@cybertec.at=
</a>&gt; writes:<br>
&gt; On Wed, 2021-06-09 at 19:54 +0000, PG Doc comments form wrote:<br>
&gt;&gt; When using psql (version 13.3) against a version 13 cluster, the m=
ethod<br>
&gt;&gt; shown in the compatibility section works whereas the methods shown=
 in the<br>
&gt;&gt; synopsis and parameters sections do not work and will throw a synt=
ax<br>
&gt;&gt; error.<br>
<br>
&gt; You must be misreading something, the new syntax works:<br>
&gt; COPY (SELECT 42 AS x) TO STDOUT (FORMAT &#39;csv&#39;, FORCE_QUOTE (x)=
);<br>
<br>
The most probable explanation seems to be that the OP is actually<br>
connecting to an 8.4 (or older) PG server.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div></div>

--000000000000e9b1fa05c482581b--