Re: ERROR: invalid input syntax for integer: - Mailing list pgsql-novice

e-letter <inpost@gmail.com> writes:
> A database table was created with the command:
> CREATE TABLE tablename (column1 bigint,date date,time time,column2 text)
> a csv file was imported, of structure:
> 123456,2000-01-01,01:10,"sometext"
> Using the command:
> \copy tablename from file.csv
> Causes the command terminal error:
>  input syntax for integer: "123456,2000-01-01,01:10,"sometext""
> CONTEXT:  COPY tablename, line 1, column column2: "123456

I don't believe that \copy will default to assuming that the file is in
csv format.  You probably need to add "format csv" or something similar
to that command.

            regards, tom lane