Re: [SQL] COPY without quoting

2012-03-15 Thread Lee Hachadoorian
On 03/15/2012 12:23 PM, Tom Lane wrote: Lee Hachadoorian 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

Re: [SQL] COPY without quoting

2012-03-15 Thread Tom Lane
Lee Hachadoorian 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 em

[SQL] COPY without quoting

2012-03-15 Thread Lee Hachadoorian
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. But