pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSimple Unload
2+ messages / 2 participants
[nested] [flat]
* Simple Unload
@ 2006-12-11 20:45 Naomi Walker <nwalke@eldocomp.com>
2006-12-11 21:19 ` Re: Simple Unload Bricklen Anderson <banderson@presinet.com>
0 siblings, 1 reply; 2+ messages in thread
From: Naomi Walker @ 2006-12-11 20:45 UTC (permalink / raw)
To: pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Simple Unload
2006-12-11 20:45 Simple Unload Naomi Walker <nwalke@eldocomp.com>
@ 2006-12-11 21:19 ` Bricklen Anderson <banderson@presinet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Bricklen Anderson @ 2006-12-11 21:19 UTC (permalink / raw)
To: Naomi Walker <nwalke@eldocomp.com>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-12-11 21:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-11 20:45 Simple Unload Naomi Walker <nwalke@eldocomp.com>
2006-12-11 21:19 ` Bricklen Anderson <banderson@presinet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox