Re: " " around fields with psql

On 02/13/2012 02:13 PM, Merlin Moncure wrote:
> On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts<jasen(at)xnet(dot)co(dot)nz> wrote:
>> On 2012-02-10, Steve Clark<sclark(at)netwolves(dot)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.

--
Stephen Clark
*NetWolves*
Director of Technology
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve(dot)clark(at)netwolves(dot)com
http://www.netwolves.com