Re: SQL Commands COPY - Mailing list pgsql-docs

From Tom Lane
Subject Re: SQL Commands COPY
Date
Msg-id 1510077.1623275238@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL Commands COPY  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: SQL Commands COPY  (Neil Bower <neilbower@gmail.com>)
List pgsql-docs
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



pgsql-docs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: SQL Commands COPY
Next
From: Daniel Gustafsson
Date:
Subject: Git is not an acronym