e-letter <inpost(at)gmail(dot)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