| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | rod(at)iol(dot)ie, dpopova(at)uvic(dot)ca, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Load Data with COPY |
| Date: | 2015-03-24 22:17:30 |
| Message-ID: | 5511E27A.7060206@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 03/24/2015 02:16 PM, Raymond O'Donnell wrote:
> On 24/03/2015 21:00, dpopova(at)uvic(dot)ca wrote:
>> I have 7,000+ rows of data in Numbers. Exported to .csv file, tried to
>> load into postgres table with COPY FROM, failed. Postgres does not
>> recognize the format:
>>
>> ERROR: invalid input syntax for integer: "project_name,...
>>
>> Is there any way to export/convert the data in Numbers into a format
>> recognizable by postgres?
>> Mac OS 10.10.6; postgres 9.3.5.2
>
> Well, the error says that you're trying to load a string,
> "project_name", into an integer column.
>
> Is there a header row in the CSV file? - if so, delete it and try again.
If it is not a header row issue then it could be the columns in the CSV
file do not match the columns in the table and that data is not matching
what the table column expects. You can specify a column list in the COPY.
>
> Ray.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dpopova | 2015-03-25 01:59:03 | Re: Load Data with COPY |
| Previous Message | John R Pierce | 2015-03-24 21:34:05 | Re: Load Data with COPY |