Monday, August 18, 2008

[SQL] COPY TO with FORCE QUOTE *

I would like to be able to force quotes on all columns in the COPY TO
command without having to name all columns explicitly. E.g.:

COPY a TO '/tmp/a.csv' WITH CSV FORCE QUOTE *;

Reading the documentation, there doesn't seem to be a way to do this.
Am I missing something? If not, could I submit this as a feature
request?

many thanks, jackson

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

No comments: