Re: psql \copy with multi-line query

[Rob Sargent <robjsargent@xxxxxxxxx>]

On 3/24/23 17:14, David G. Johnston wrote:

On Fri, Mar 24, 2023 at 4:04 PM Rob Sargent <robjsargent@xxxxxxxxx> 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.

    Thank you.  I realize
      now I went to COPY not \copy docs.