Re: Simple Unload - Mailing list pgsql-admin

From Bricklen Anderson
Subject Re: Simple Unload
Date
Msg-id 457DCB49.300@presinet.com
Whole thread Raw
In response to Simple Unload  (Naomi Walker <nwalke@eldocomp.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Simple Unload
Next
From: Manuel Trujillo
Date:
Subject: Migration problems with encoding.