On 02/13/2012 02:13 PM, Merlin Moncure wrote:
On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts <jasen@xnet.co.nz> wrote:
On 2012-02-10, Steve Clark <sclark@netwolves.com> wrote:
Is there a way with psql to get column output to be
"data1","data2",...,"datan"
assuming you are trying to be compatible with CSV:
copy ( your_query_here ) to stdout with csv header ;
yeah -- that's the best way if you want actual csv, from psql you'd
probably want to do \copy:
postgres=# \copy (select 1, '"', 'ab,c') to stdout csv header;
?column?,?column?,?column?
1,"""","ab,c"
note that per csv rules columns are only required to be quoted to
protect from unambiguous parsing. also, double quotes in your field
will be escaped.
merlin
Thanks to all that replied.