Using COPY

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

Responses

Browse pgsql-novice by date

  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