Postgres Pro
Downloads
Home   >   mailing lists

Re: psql \copy with multi-line query - Mailing list pgsql-general

From David G. Johnston
Subject Re: psql \copy with multi-line query
Date
Msg-id CAKFQuwYHXdsx6MQ_jZWU3mgm+5GZVD6BEeB_gL7++pFGyM_ZXw@mail.gmail.com
Whole thread Raw
In response to psql \copy with multi-line query  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: psql \copy with multi-line query  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view
On Fri, Mar 24, 2023 at 4:04 PM Rob Sargent <robjsargent@gmail.com> wrote:
Using version 13 psql on version 14 server and having trouble sending a multi-line select in the \copy.  I don't see any remark about this in the man page.

The copy meta-command cannot contain newlines.  You should use "COPY ... TO STDOUT" directly instead.

All of this is discussed under "\copy" in the documentation (including notes).

https://www.postgresql.org/docs/current/app-psql.html

David J.

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: psql \copy with multi-line query
Next
From: Rob Sargent
Date:
Subject: Re: psql \copy with multi-line query