Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 394C94761DB for ; Wed, 11 Dec 2002 12:40:44 -0500 (EST) Received: from smtp0.libero.it (smtp0.libero.it [193.70.192.33]) by postgresql.org (Postfix) with ESMTP id A4CDD47618C for ; Wed, 11 Dec 2002 12:40:43 -0500 (EST) Received: from libero.it (193.70.192.61) by smtp0.libero.it (6.7.015) id 3DE229DC00135FD3 for pgsql-sql@postgresql.org; Wed, 11 Dec 2002 18:40:49 +0100 Date: Wed, 11 Dec 2002 18:40:48 +0100 Message-Id: Subject: =?iso-8859-1?Q?error_in_copy_table_from_file?= MIME-Version: 1.0 X-Sensitivity: 3 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable From: "=?iso-8859-1?Q?mzmaxmail@libero.it?=" To: "=?iso-8859-1?Q?pgsql-sql?=" X-XaM3-API-Version: 3.2 R28 (B53) X-type: 0 X-SenderIP: 193.205.203.16 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/132 X-Sequence-Number: 10720 hi=0D i'm using postgreSQL 7.3 b1.=0D when i try to populate my tables with the files that contain all the =0D data, i have some troblues:=0D for example, my table has the following fields:=0D -date (date)=0D -id_street (int2)=0D -flux_h_0_1 (float8)=0D -flux_h_1_2 (float8)=0D .=0D .=0D .=0D -flux_h_23_0 (float8)=0D =0D the input file has semicolon as delimiters=0D and it't like this=0D 2000-01-01;25;325.236;-0.123; and so on ;1.2=0D 2000-01-01;26;323.45;-1.23; 1.66=0D =0D if i execute the command=0D =0D copy table from 'path/file' using delimiters ';'=0D it returns the following:=0D =0D 'RROR: copy: line 1, Bad float8 input format '-0.123=0D =0D i can't understand why it's saying it's wrong!!!!=0D or another error in importing other tables can be:=0D =0D ": can't parse "ne 1, pg_atoi: error in "125=0D =0D and 125 is the last number of a row.=0D =0D what can i do to solve this problem?=0D thanx in advance for your help=0D =0D massimo=0D