Am Di, 2003-09-02 um 17.22 schrieb Juan Francisco Diaz:
> Hi, im trying to use the copy command to load some data in my tables but i
> get the following message:
>
> 000081": can't parse "pg_atoi: error in "0
>
> When i execute the following command:
>
> copy carconffuente from
> '/users/juanf/documents/scriptspostgresql/tablacarconffuente'
>
> The file structure is like this:
>
> 000081 16 53 60 0.84999999999999998 70 0 0 0
> 000081 17 29 60 0.80000000000000004 70 0 0 0
> 000081 18 37 60 0.94999999999999996 70 0 0 0
>
> And the first column's type is CHAR(6).
Are you sure that the table has _exactly_ these columns ?
Try specifying the columnnames explicitly:
COPY table (colname1, colname2, ...) FROM ...
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de