Re: db partial dumping with pg_dump - Mailing list pgsql-hackers

On Tue, 2002-08-13 at 20:24, Tom Lane wrote:
> 
> What would seem to make sense is adding a WHERE-clause option to
> COPY TO, and then you could go
>     COPY table TO 'myfile' WHERE ...

What about :

COPY table TO 'myfile' [ WHERE cond ] [ AS INSERT [ WITH COLUMN ] ];

to get the data as INSERT INTO statements (pg_dump -d), with optional
column list (pg_dump -D)

----------------
Hannu