Re: [SQL] error in copy table from file

2002-12-11 Thread Manfred Koizar
On Wed, 11 Dec 2002 18:40:48 +0100, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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 beginni

Re: [SQL] error in copy table from file

2002-12-11 Thread Stephan Szabo
On Wed, 11 Dec 2002, [iso-8859-1] [EMAIL PROTECTED] 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

[SQL] error in copy table from file

2002-12-11 Thread [EMAIL PROTECTED]
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 i