Обсуждение: pg_atoi: error in.....: can't parse..."

Поиск
Список
Период
Сортировка

pg_atoi: error in.....: can't parse..."

От
"stessy"
Дата:
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.
 
 

Re: pg_atoi: error in.....: can't parse..."

От
Peter Eisentraut
Дата:
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