On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts <jasen@xxxxxxxxxx> wrote: > On 2012-02-10, Steve Clark <sclark@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
