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 "","",hiddenem...@hotmail.com,"",John Wayne See how the email and the company aren't into two "? *What I need is:* > "","","hiddenem...@hotmail.com","","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