Re: Error Importing CSV File

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, shrek(at)shreks-place(dot)com
Subject: Re: Error Importing CSV File
Date: 2011-07-15 17:44:17
Message-ID: 4E207C71.9060206@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/15/2011 10:42 AM, Steve Crawford wrote:
> .
>
>> Error Message
>> -------------
>> ERROR: invalid input syntax for integer: "96799"
>> CONTEXT: COPY geo_data, line 1, column id: "96799"
> If you have given us a correct table layout, there is no column 96799
> ...
Oops, meant column "id".

Cheers,
Steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2011-07-15 17:54:24 Re: Error Importing CSV File
Previous Message Tom Lane 2011-07-15 17:44:15 Re: Error Importing CSV File