Load Data with COPY

From: dpopova(at)uvic(dot)ca
To: pgsql-general(at)postgresql(dot)org
Subject: Load Data with COPY
Date: 2015-03-24 21:00:29
Message-ID: 07e603e92ec94f324261005048f7e8e0.squirrel@wm3.uvic.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2015-03-24 21:16:26 Re: Load Data with COPY
Previous Message Kevin Grittner 2015-03-24 19:47:02 Re: Index corruption