From: Sebastian P. Luque <spluque@gmail.com>
To: Ben Morrow <ben@morrow.me.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: \copy multiline
References: <20121129080127.GA54729@anubis.morrow.me.uk>
Mail-Followup-To: Ben Morrow <ben@morrow.me.uk>, pgsql-sql@postgresql.org
Date: Thu, 29 Nov 2012 09:31:10 -0600
In-Reply-To: <20121129080127.GA54729@anubis.morrow.me.uk> (Ben Morrow's
	message of "Thu, 29 Nov 2012 08:01:31 +0000")
Message-ID: <87boego281.fsf@kolob.subpolar.dyndns.org>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux)
Organization: University of Manitoba
MIME-Version: 1.0
Content-Type: text/plain
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On Thu, 29 Nov 2012 08:01:31 +0000,
Ben Morrow <ben@morrow.me.uk> wrote:

> Quoth spluque@gmail.com (Seb):
>> 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?

> CREATE TEMPORARY VIEW?

Of course, that's perfect.

Thanks!

-- 
Seb


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql