COPY (SELECT name_first name_last, email, companyFROM clients)TO '/var/lib/pgsql/test1.csv' DELIMITER ',' csv HEADER QUOTE '"';
"","",hiddenemail@hotmail.com,"",John Wayne
See how the email and the company aren't into two "?
What I need is:
"","","hiddenemail@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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных