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