Hello
COPY doesn't like '\n' too.
Replace '\n' by '\\n'
Regards
Pavel Stehule
2011/5/10 Ivan Sergio Borgonovo <mail@webthatworks.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>