Re: Feature: give pg_dump a WHERE clause expression

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 <pubaddr5@davyandbeth.com> 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 <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate