Re: ERROR: invalid input syntax for integer: SQL state: 22P02

avalon78 geek  writes:
> i issue the following sql command
> COPY cust
>  FROM 'C:\Program Files\PostgreSQL\9.1\customers.txt'
> WITH DELIMITER ';'  ;

> and i get an error
> ERROR: invalid input syntax for integer: "13"
> SQL state: 22P02

That looks like you have a Unicode BOM marker at the start of the file.
There are some (pretty broken IMO) Windows editors that add such behind
your back in order to mark a text file as being text ... of course, it's
not plain text anymore, and BOM is useless/illegal in UTF-8 anyway, but
standards compliance was never Microsoft's strong suit.

Save the file with some other editor.

			regards, tom lane