Re: Feature: give pg_dump a WHERE clause expression

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Davy Durham <pubaddr5(at)davyandbeth(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Feature: give pg_dump a WHERE clause expression
Date: 2008-06-02 02:02:24
Message-ID: 20080602020224.GH31154@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

* Davy Durham (pubaddr5(at)davyandbeth(dot)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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Davy Durham 2008-06-02 02:05:32 Re: Feature: give pg_dump a WHERE clause expression
Previous Message Davy Durham 2008-06-02 00:55:57 Re: Feature: give pg_dump a WHERE clause expression