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.