How about something like:
BEGIN TRAN
SELECT INTO TEMP TABLE foobar WHERE <cond_list>
COPY foobar TO data.txt
COMMIT
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of CSN
> Sent: Thursday, December 08, 2005 5:29 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] copy with where query?
>
> Is it possible to copy data from a table into a file and specify a
query
> for what data should be
> included? e.g.
>
> \copy table1 to 'data.txt' where col1=true
>
>
> thanks
> csn
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings