Hi guys, I'm exporting some data for testing purpose.
COPY (SELECT > name_first > name_last, > email, > company > FROM > clients > ) > TO '/var/lib/pgsql/test1.csv' DELIMITER ',' csv HEADER QUOTE '"'; cat /var/lib/pgsql/test1.csv "","",[email protected],"",John Wayne See how the email and the company aren't into two "? *What I need is:* > "","","[email protected]","","John Wayne" I thought that by putting QUOTE the COPY would do that? Is there any way I can put the " into those fields? Cheers Patrick
