Re: Problem with COPY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with COPY
Дата
Msg-id 5892.1372859504@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with COPY  (Brauner Oliveira <brauner.rno@gmail.com>)
Ответы Re: Problem with COPY  (Brauner Oliveira <brauner.rno@gmail.com>)
Список pgsql-novice
Brauner Oliveira <brauner.rno@gmail.com> writes:
> ERROR: value too long for type character varying(8)
> SQL state: 22001
> Context: COPY $tablename, line 1, column $colum_name: "69900900"

Is that the first field of the first line?

> The file is well formatted and Encoded in UTF-8:

I'm suspicious that you prepared the file in some text editor that
"helpfully" inserted an invisible BOM (byte order mark) character at the
start of the file.  Windows editors in particular seem to think this is
a good idea.

            regards, tom lane


В списке pgsql-novice по дате отправления:

Предыдущее
От: Brauner Oliveira
Дата:
Сообщение: Problem with COPY
Следующее
От: Brauner Oliveira
Дата:
Сообщение: Re: Problem with COPY