| From: | Bricklen Anderson <banderson(at)presinet(dot)com> |
|---|---|
| To: | Naomi Walker <nwalke(at)eldocomp(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Simple Unload |
| Date: | 2006-12-11 21:19:05 |
| Message-ID: | 457DCB49.300@presinet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manuel Trujillo | 2006-12-12 09:47:53 | Migration problems with encoding. |
| Previous Message | Naomi Walker | 2006-12-11 20:45:37 | Simple Unload |