Re: Load Data with COPY

On 24/03/2015 21:00, dpopova@uvic.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.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie