From: | Juan Francisco Diaz <j-diaz(at)publicar(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Using COPY |
Date: | 2003-09-02 15:22:04 |
Message-ID: | BB7A1FCC.2A6%j-diaz@publicar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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).
The file was exported from mssqlserver2000 with ANSI coding, <cr> as row
separator, no quotes for the texts, and TAB as the column separator.
Thanks a lor in advance
JuanF
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2003-09-02 15:38:59 | Re: Using COPY |
Previous Message | Jeffrey Melloy | 2003-09-02 14:43:28 | Re: SELECT woes |