Re: COPY without quoting

Lee Hachadoorian <lee.hachadoorian@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