Re: Error Importing CSV File - Mailing list pgsql-general

From Steve Crawford
Subject Re: Error Importing CSV File
Date
Msg-id 4E207C71.9060206@pinpointresearch.com
Whole thread Raw
In response to Re: Error Importing CSV File  (Steve Crawford <scrawford@pinpointresearch.com>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error Importing CSV File
Next
From: Scott Ribe
Date:
Subject: Re: Error Importing CSV File