On 09/21/2016 02:23 AM, Patrick B wrote:
I'm exporting some data for testing purpose.
TO '/var/lib/pgsql/test1.csv' DELIMITER ',' csv HEADER QUOTE '"';
In your COPY you have fields and in the CSV file you have five.
Are you looking at the correct file?
See how the email and the company aren't into two "?
Have no idea what you are trying to say.
hiddenem...@hotmail.com looks like a correct email to me.
Maybe if you show what the data is in the table?
*What I need is:*
I thought that by putting QUOTE the COPY would do that?
Is there any way I can put the " into those fields?
Sent via pgsql-general mailing list (firstname.lastname@example.org)
To make changes to your subscription: