Re: " " around fields with psql

[Steve Clark <sclark@xxxxxxxxxxxxx>]

On 02/13/2012 02:13 PM, Merlin Moncure wrote:

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

Thanks to all that replied.

--
Stephen Clark
NetWolves
Director of Technology
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve.clark@xxxxxxxxxxxxx
http://www.netwolves.com