Re: psql \copy with multi-line query

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.