On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts <ja...@xnet.co.nz> wrote: > On 2012-02-10, Steve Clark <scl...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general