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

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