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

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема COPY complaining about unquoted carriage return found in data... in a quoted field
Дата
Msg-id 20110510142840.27cf8107@dawn.webthatworks.it
обсуждение исходный текст
Ответы Re: COPY complaining about unquoted carriage return found in data... in a quoted field
Список 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 по дате отправления:

Предыдущее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: FILLFACTOR and increasing index
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: COPY complaining about unquoted carriage return found in data... in a quoted field