On 24/03/2015 21:00, dpop...@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 r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
