Re: 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(dot)klaver(at)aklaver(dot)com