Postgres Pro
Downloads
Home   >   mailing lists

Load Data with COPY - Mailing list pgsql-general

From dpopova@uvic.ca
Subject Load Data with COPY
Date
Msg-id 07e603e92ec94f324261005048f7e8e0.squirrel@wm3.uvic.ca
Whole thread Raw
Responses Re: Load Data with COPY  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
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

Please, advise. Thank you,

Diana

pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Index corruption
Next
From: Raymond O'Donnell
Date:
Subject: Re: Load Data with COPY