Re: Feature: give pg_dump a WHERE clause expression
David Fetter <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.patches |
|---|---|
| Message-ID | <[email protected]> |
On Sun, Jun 01, 2008 at 02:08:47PM -0500, Davy Durham wrote: > On Sun, 2008-06-01 at 10:43 -0400, Tom Lane wrote: > > Davy Durham <[email protected]> writes: > > > I have added a new parameter, -w/--where=EXPR This lets you > > > specify an expression that will be used in a WHERE clause when > > > the data is dumped. > > > > This seems pretty poorly thought out. It can hardly work in a > > dump of more than one table, which means that there's not any real > > reason to use pg_dump at all. Just do a COPY (SELECT ...) TO > > somefile. > > Well, my primary reason for writing the patch was to have a standard > SQL file using INSERT statements in order to load the some of a > table's data into a database other than postgresql which does not > support the COPY statement. Have you tried DBI-Link <http://pgfoundry.org/projects/dbi-link/>? Cheers, David. -- David Fetter <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-patches mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches