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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
