Re: [GENERAL] No quotes in output of "psql \copy CSV"

2010-06-29 Thread Arnaud Lesauvage
Le 29/06/2010 14:40, Sam Mason a écrit : On Tue, Jun 29, 2010 at 02:24:00PM +0200, Arnaud Lesauvage wrote: I'd like to generate CSV files from the output of a query. I can't get the srings in the output to be quoted though. I thought that this was the default for CSV, and even adding the "QUO

Re: [GENERAL] No quotes in output of "psql \copy CSV"

2010-06-29 Thread Sam Mason
On Tue, Jun 29, 2010 at 02:24:00PM +0200, Arnaud Lesauvage wrote: > I'd like to generate CSV files from the output of a query. > I can't get the srings in the output to be quoted though. I thought that > this was the default for CSV, and even adding the "QUOTE" parameter does > not help : > > p

[GENERAL] No quotes in output of "psql \copy CSV"

2010-06-29 Thread Arnaud Lesauvage
Hi all, I'd like to generate CSV files from the output of a query. The files must be generated on the client, so I was planning on using psql \copy command. I can't get the srings in the output to be quoted though. I thought that this was the default for CSV, and even adding the "QUOTE" paramet