Thread: error in copy table from file

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

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.

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

ServusManfred