Re: Feature: give pg_dump a WHERE clause expression - Mailing list pgsql-patches

On Sun, 2008-06-01 at 22:02 -0400, Stephen Frost wrote:
> * Davy Durham (pubaddr5@davyandbeth.com) wrote:
> > To reiterate, it is not possible to use the COPY command to create
> > standard SQL INSERT statements that can be conveniently loaded by
> > another db. No?
>
> Erm, thankfully, PostgreSQL (what you're loading the data into?) can
> take more than just SQL INSERT statements.
>

No, the database I'm loading into is not PostgreSQL, but that's okay.  I
think that was someone else.

> Of course, on the other hand, you *could* use COPY to create SQL INSERT
> statements through an appropriately crafted query.  PG makes that
> reasonably straight-forward, actually.
>
>     Stephen