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(dot)bath(at)unix(dot)net