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
