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

Hi,

On 1 January 2012 14:01, avalon78 geek <avalon78(dot)gr(at)gmail(dot)com> wrote:

> hi guys,
> i am new to pgsql and i am facing a strange problem which i cannot
> solve.i want to import data from a txt file to the table cust
>
> the table is
> CREATE TABLE cust
> (
> custid integer NOT NULL,
> custOccupation varchar(30) NOT NULL,
> PRIMARY KEY(custid)
> }
>
> and the txt file contains
> 13;developer
> 22;sales manager
> etc
>
> 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
>
> i would appreciate if you could help me
>
> best regards and a happy new year!:)
>

I have no experience using text mode but have you tried CSV Mode?

e.g.
COPY cust
FROM 'C:\Program Files\PostgreSQL\9.1\
>
> customers.txt'
> WITH DELIMITER ';' CSV ;

HTH, happy new year.

--
Craig

() ascii ribbon campaign - against html mail
/\