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