Re: convert text file to database - Mailing list pgsql-novice

e-letter <inpost@gmail.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