COPY complaining about unquoted carriage return found in data... in a quoted field - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject COPY complaining about unquoted carriage return found in data... in a quoted field
Date
Msg-id 20110510142840.27cf8107@dawn.webthatworks.it
Whole thread Raw
Responses Re: COPY complaining about unquoted carriage return found in data... in a quoted field
List pgsql-general
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


pgsql-general by date:

Previous
From: tv@fuzzy.cz
Date:
Subject: Re: FILLFACTOR and increasing index
Next
From: Pavel Stehule
Date:
Subject: Re: COPY complaining about unquoted carriage return found in data... in a quoted field