Re: Feature: give pg_dump a WHERE clause expression

Stephen Frost <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.patches
Message-ID <[email protected]>
* Davy Durham ([email protected]) 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
signature.asc (application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIQ1SwrzgMPqB3kigRAisBAJsGvuhefeVSdk2mh0U/L4cN3tOTTQCfeXcm
LRtD+GRaBKPMVBdJUQ9IkYk=
=3uCm
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.