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