Lee Hachadoorian <lee.hachadoor...@gmail.com> writes: > COPY ... TO ... WITH CSV defaults to quoting string fields with embedded > delimiters, quotes, and newlines. In pgAdmin I can execute to file and > specify "no quoting" for the output, in which case I get (what I want) a > file with no quotes, even though there are embedded commas in the > strings.
Uh ... why exactly would you want that? It seems impossible to parse such a file. If what you want is an unparsable file, you could just strip out the quotes with "sed" after the fact. But COPY is not in the business of producing non-machine-readable files, so the fact that it doesn't have an option for this doesn't bother me. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql