Hi community,

CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a));

a.csv:
1,"a,b",2

COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV;

The copy command fails because there is a comma in the second field,but this is a fully legal and compliant CSV format,how can I avoid this problem?or it is a bug?

Reply via email to