Re: generate CSV with Copy+Quotes - Postgres 9.2

[Patrick B <patrickbakerbr@xxxxxxxxx>]

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

--  

 

Thanks! FORCE QUOTE was exactly what I needed.

Patrick.