On 03/20/2018 04:32 AM, Nicolas Paris wrote:
Hello
I get an error when loading this kind of csv:
test.csv:
"hello ""world"""
"\."
"this
works
"
"this
\.
does
not"
table:
create table test (field text);
sql:
\copy test (field) from 'test.csv' CSV quote '"' ESCAPE '"';
ERROR:
Hello
I get an error when loading this kind of csv:
> test.csv:
"hello ""world"" "
"\."
"this
works
"
"this
\.
does
not"
> table:
create table test (field text);
> sql:
\copy test (field) from 'test.csv' CSV quote '"' ESCAPE '"';
ERROR: unterminated CSV quoted field
CONTEXTE : COPY test,