pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feederror in copy table from file
3+ messages / 3 participants
[nested] [flat]
* error in copy table from file
@ 2002-12-11 17:40 mzmaxmail@libero.it <mzmaxmail@libero.it>
2002-12-11 18:20 ` Re: error in copy table from file Stephan Szabo <sszabo@megazone23.bigpanda.com>
2002-12-11 18:59 ` Re: error in copy table from file Manfred Koizar <mkoi-pg@aon.at>
0 siblings, 2 replies; 3+ messages in thread
From: mzmaxmail@libero.it @ 2002-12-11 17:40 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: error in copy table from file
2002-12-11 17:40 error in copy table from file mzmaxmail@libero.it <mzmaxmail@libero.it>
@ 2002-12-11 18:20 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
1 sibling, 0 replies; 3+ messages in thread
From: Stephan Szabo @ 2002-12-11 18:20 UTC (permalink / raw)
To: mzmaxmail@libero.it <mzmaxmail@libero.it>; +Cc: pgsql-sql
On Wed, 11 Dec 2002, [iso-8859-1] mzmaxmail@libero.it wrote:
> 'RROR: copy: line 1, Bad float8 input format '-0.123
Looks like you have end of line issues (given the fact that the
second quote is at the beginning of the line. You
probably have carriage returns at the end of lines.
If you get rid of those, it probably will work.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: error in copy table from file
2002-12-11 17:40 error in copy table from file mzmaxmail@libero.it <mzmaxmail@libero.it>
@ 2002-12-11 18:59 ` Manfred Koizar <mkoi-pg@aon.at>
1 sibling, 0 replies; 3+ messages in thread
From: Manfred Koizar @ 2002-12-11 18:59 UTC (permalink / raw)
To: mzmaxmail@libero.it <mzmaxmail@libero.it>; +Cc: pgsql-sql
On Wed, 11 Dec 2002 18:40:48 +0100, "mzmaxmail@libero.it"
<mzmaxmail@libero.it> wrote:
>copy table from 'path/file' using delimiters ';'
>
>it returns the following:
>
>'RROR: copy: line 1, Bad float8 input format '-0.123
^
This belongs to the end of the error message. Finding it here at the
beginning of the line makes me think your file has DOS style end of
lines (CR/LF). Convert them to Unix style (LF only).
Servus
Manfred
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-12-11 18:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-11 17:40 error in copy table from file mzmaxmail@libero.it <mzmaxmail@libero.it>
2002-12-11 18:20 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2002-12-11 18:59 ` Manfred Koizar <mkoi-pg@aon.at>
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