e-letter <inpost(at)gmail(dot)com> writes:
> I tried to import 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