Naomi Walker wrote:
From time to time, I need to unload rows to a delimited file,
specifically with a "where" clause.
I've cobbled a script together to do this, but it seems like a
reasonable utility to support. Sort
of a pg_dump on steroids..
Have I missed the simple way to do this? Would someone consider adding
such a utility or adding
this to pg_dump?
Naomi
8.2 COPY appears to be able to output in csv format, using a WHERE
clause, though I've not tried it.
http://www.postgresql.org/docs/8.2/static/sql-copy.html
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
