> > >> > > Perhaps you mean you want to quote of all strings? For that you use FORCE > QUOTE. > eg: > COPY (SELECT > name_first > name_last, > email, > company > FROM > clients > ) > TO '/var/lib/pgsql/test1.csv' DELIMITER ',' > csv HEADER QUOTE '"'; > FORCE QUOTE name_first, name_last, email, company; > > Please RTFM > *https://www.postgresql.org/docs/9.4/static/sql-copy.html > <https://www.postgresql.org/docs/9.4/static/sql-copy.html>* > -- >
> Thanks! FORCE QUOTE was exactly what I needed. Patrick.
