Postgres Pro
Downloads
Home   >   mailing lists

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

From Rob Sargent
Subject Re: psql \copy with multi-line query
Date
Msg-id 8466823d-0b88-883e-ef51-e5df047bbe91@gmail.com
Whole thread Raw
In response to Re: psql \copy with multi-line query  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On 3/24/23 17:14, David G. Johnston wrote:
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.

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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: psql \copy with multi-line query
Next
From: Inzamam Shafiq
Date:
Subject: Re: PostgreSQL vs MariaDB