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

From Stephen Frost
Subject Re: Feature: give pg_dump a WHERE clause expression
Date
Msg-id 20080602020224.GH31154@tamriel.snowman.net
Whole thread Raw
In response to Re: Feature: give pg_dump a WHERE clause expression  (Davy Durham <pubaddr5@davyandbeth.com>)
Responses Re: Feature: give pg_dump a WHERE clause expression
List pgsql-patches
* 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.

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

Attachment

pgsql-patches by date:

Previous
From: Davy Durham
Date:
Subject: Re: Feature: give pg_dump a WHERE clause expression
Next
From: Davy Durham
Date:
Subject: Re: Feature: give pg_dump a WHERE clause expression