Lead and tail quotes with \pset fieldsep - Mailing list pgsql-sql

From Bath, David
Subject Lead and tail quotes with \pset fieldsep
Date
Msg-id 200603201037.07638.dave.bath@unix.net
Whole thread Raw
Responses Re: Lead and tail quotes with \pset fieldsep
List pgsql-sql
Folks

If I want psql to generate CSV files fully-double-quoted I can
use pset as follows
psql> \pset fieldsep ","
However this does not put a quote before the first field and
after the last, so each row comes out as
1234","blahblah","sdfgsg","foo","bar

Is there a way to use psql to give rows like
1234","blahblah","sdfgsg","foo","bar
or is there another tool I should use.

COPY doesn't deal with views and restrictions well so it is
not an option.

Thanks in advance
-- 
David T. Bath
dave.bath@unix.net



pgsql-sql by date:

Previous
From: Svenne Krap
Date:
Subject: Re: How to call table returning function with other table
Next
From: Bruce Momjian
Date:
Subject: Re: Lead and tail quotes with \pset fieldsep