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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: avalon78 geek <avalon78(dot)gr(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: invalid input syntax for integer: SQL state: 22P02
Date: 2012-01-01 18:08:06
Message-ID: 8561.1325441286@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

avalon78 geek <avalon78(dot)gr(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Craig Barnes 2012-01-01 20:07:07 Re: ERROR: invalid input syntax for integer: SQL state: 22P02
Previous Message Tom Lane 2012-01-01 18:01:58 Re: How to declare a variable in a postgresql query in sql language ?