Re: Problem with COPY - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problem with COPY
Date
Msg-id 5892.1372859504@sss.pgh.pa.us
Whole thread Raw
In response to Problem with COPY  (Brauner Oliveira <brauner.rno@gmail.com>)
Responses Re: Problem with COPY  (Brauner Oliveira <brauner.rno@gmail.com>)
List 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 by date:

Previous
From: Brauner Oliveira
Date:
Subject: Problem with COPY
Next
From: Brauner Oliveira
Date:
Subject: Re: Problem with COPY