Thread: pg_atoi: error in.....: can't parse..."
hi all,
I have this error "pg_atoi: error in "PARC INDUSTRIEL": can't parse "PARC INDUSTRIEL" " when I try to copy data from file to database.
The 2 databases have the same encoding 'LATIN1'.
The data types are all the same in two tables.
These are alls requests I use to copy data.
First database
psql gravoline
CREATE TABLE adr AS SELECT(id_client, rue::text,num::text,"code postal"::text,localite::text) from adresse;
COPY adr to '/usr/adr.sql' USING DELIMITERS '|';
Second database
psql pdg
COPY adresse FROM '/usr/adr.sql' USING DELIMITERS '|';
ps: excuse for my english.
stessy writes: > I have this error "pg_atoi: error in "PARC INDUSTRIEL": can't parse > "PARC INDUSTRIEL" " when I try to copy data from file to database. The copy is seeing the value "PARC INDUSTRIEL" while it is trying to fill a numerical column. Make sure the order and type of your columns matches. -- Peter Eisentraut peter_e@gmx.net