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.
|