COPY error when \. char

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: unterminated CSV quoted field
CONTEXTE : COPY test, line 7: ""this
"

Apparently, having the \. string in a single line make it break.
Is this normal ?

https://www.postgresql.org/docs/10/static/sql-copy.html
"Because backslash is not a special character in the CSV format, \., the
end-of-data marker, could also appear as a data value. To avoid any
misinterpretation, a \. data value appearing as a lone entry on a line
is automatically quoted on output, and on input, if quoted, is not
interpreted as the end-of-data marker. If you are loading a file created
by another application that has a single unquoted column and might have
a value of \., you might need to quote that value in the input file."

Thanks

--
Adrian Klaver
adrian.klaver@aklaver.com