copy with where query?

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: copy with where query?
Date: 2005-12-09 01:28:51
Message-ID: 20051209012851.83682.qmail@web52905.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-12-09 01:48:37 Re: copy with where query?
Previous Message Chris Velevitch 2005-12-09 00:19:01 How efficient is select currval?