by tgl@[EMAIL PROTECTED]
(Tom Lane)
Apr 18, 2008 at 10:49 AM
e-letter <inpost@[EMAIL PROTECTED]
> writes:
> I tried to im****t the csv file using the command:
> chessmatches=# COPY chessgames FROM '/absolute/path/filename.csv';
> ERROR: invalid input syntax for integer: "Event..."
Umm ... you didn't tell it the data is in CSV. I think you need at
least the HEADER option too. See the COPY manual page:
http://www.postgresql.org/docs/8.3/static/sql-copy.html
regards, tom lane
--
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
