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