There seems to be no reason it should be looking for an integer, if your table definition as shown is correct. You
don'thave any integers listed.
Also, why does it think that the column id is 96799?
Stupid question, but are you logged into the right database? Maybe a different db has a different table definition for
thattable name?
Maybe it is using a different file than you think it is? I had to specify the full path to get the COPY to work on my
testdatabase.
When I created the same table as you specified, and created a test CSV file, it worked fine both with and without
quotes.
Susan
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Bryan Nelson
Sent: Friday, July 15, 2011 9:04 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Error Importing CSV File
I am having problems importing a CSV file of sample data for testing
in a web app.
Columns & Types
-------------------
zip_code - text
lattitude - float8
longitude - float8
city - text
state - text
county - text
Some Sample Data From CSV File
------------------------------
96799,-7.209975,-170.7716,PAGO PAGO,AS,AMERICAN SAMOA
96941,7.138297,151.503116,POHNPEI,FM,FEDERATED STATES OF MICRO
96942,7.138297,151.503116,CHUUK,FM,FEDERATED STATES OF MICRO
COPY Command
------------
COPY geo_data FROM 'geo_data2.csv' DELIMITERS ',' CSV;
Error Message
-------------
ERROR: invalid input syntax for integer: "96799"
CONTEXT: COPY geo_data, line 1, column id: "96799"
I can't figure out why it keeps choking with "invalid syntax for
integer" since the field was created as "text".
Any and all help greatly appreciated!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general