\copy multiline - Mailing list pgsql-sql

From Seb
Subject \copy multiline
Date
Msg-id 87r4ndnlfn.fsf@kolob.subpolar.dyndns.org
Whole thread Raw
Responses Re: \copy multiline
List pgsql-sql
Hi,

I use \copy to output tables into CSV files:

\copy (SELECT ...) TO 'a.csv' CSV

but for long and complex SELECT statements, it is cumbersome and
confusing to write everything in a single line, and multiline statements
don't seem to be accepted.  Is there an alternative, or am I missing an
continuation-character/option/variable that would allow multiline
statements in this case?

Cheers,

-- 
Seb



pgsql-sql by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Joining several rows into only one
Next
From: Guillaume Lelarge
Date:
Subject: Re: \copy multiline