Readers,
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
What is my mistake please?