From: mzmaxmail@libero.it <mzmaxmail@libero.it>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: error in copy table from file
Date: Wed, 11 Dec 2002 18:40:48 +0100
Message-ID: <H6YUG0$F8E94BAAD19150F488C52E174AF2FFB7@libero.it> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mzmaxmail@libero.it
Subject: Re: error in copy table from file
In-Reply-To: <H6YUG0$F8E94BAAD19150F488C52E174AF2FFB7@libero.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox