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