How about something like: BEGIN TRAN SELECT INTO TEMP TABLE foobar WHERE <cond_list> COPY foobar TO data.txt COMMIT
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
