public inbox for [email protected]  

help / color / mirror / Atom feed

From: Neil Bower <[email protected]>
To: Tom Lane <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: SQL Commands COPY
Date: Fri, 11 Jun 2021 13:16:29 -0600
Message-ID: <CAKEGPH-A-mkjdfq17z3Nia+b=QOa0aUPdDQjcU6Fq-SkpRjSMw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>

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 <[email protected]> wrote:

> Laurenz Albe <[email protected]> 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
>

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: SQL Commands COPY
  In-Reply-To: <CAKEGPH-A-mkjdfq17z3Nia+b=QOa0aUPdDQjcU6Fq-SkpRjSMw@mail.gmail.com>

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

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