error in copy table from file

Поиск
Список
Период
Сортировка
От mzmaxmail@libero.it
Тема error in copy table from file
Дата
Msg-id H6YUG0$F8E94BAAD19150F488C52E174AF2FFB7@libero.it
обсуждение исходный текст
Ответы Re: error in copy table from file  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: error in copy table from file  (Manfred Koizar <mkoi-pg@aon.at>)
Список pgsql-sql
hi
i'm using postgreSQL 7.3 b1.
when i try to populate my tables with the files that contain all the 
data, i have some troblues:
for example, my table has the following fields:
-date (date)
-id_street (int2)
-flux_h_0_1 (float8)
-flux_h_1_2 (float8)
.
.
.
-flux_h_23_0 (float8)

the input file has semicolon as delimiters
and it't like this
2000-01-01;25;325.236;-0.123; and so on ;1.2
2000-01-01;26;323.45;-1.23;             1.66

if i execute the command

copy table from 'path/file' using delimiters ';'
it returns the following:

'RROR:  copy: line 1, Bad float8 input format '-0.123

i can't understand why it's saying it's wrong!!!!
or another error in importing other tables can be:

": can't parse "ne 1, pg_atoi: error in "125

and 125 is the last number of a row.

what can i do to solve this problem?
thanx in advance for your help

massimo




В списке pgsql-sql по дате отправления:

Предыдущее
От: David M
Дата:
Сообщение: Re: trigger to maintain relationships
Следующее
От: "A.M."
Дата:
Сообщение: Getting the latest unique items