Re: COPY complaining about unquoted carriage return found in data... in a quoted field

Hello

COPY doesn't like '\n' too.

Replace '\n' by '\\n'

Regards

Pavel Stehule

2011/5/10 Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>:
> I'm on pg 8.3.14
> I'm trying to import a csv with
>
> \copy anagraficaclienti from
>  'myfile.csv'
>  delimiter as E'       '  -- this is a tab \t
>  null as 'NULL'
>  csv
>    header
>    quote as E'"'
>    escape as E'\\'
>
> What I get is
>
> ERROR:  unquoted carriage return found in data
> HINT:  Use quoted CSV field to represent carriage return.
> CONTEXT:  COPY anagraficaclienti, line 48656
>
> The record actually contains \r\n in a field but up to my
> understanding that field is quoted.
> I think what seems to be wrong is my understanding of what postgres
> consider quoted field.
>
> the content in hex
> 09 22 56 | 69 61 20 46 | 61 65 6E 74 | 69 6E 61 2C
> 20 35 33 0D | 0A 22 09 22 | 35 30 30 31 | 34 22 09
>
> \t"Via Faentina, 53\r\n"\t
>
> What am I missing?
>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>