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:
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?
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2011-09-22 00:07:04|
|Subject: Re: ERROR: invalid input syntax for integer: |
|Previous:||From: Tom Lane||Date: 2011-09-21 15:11:18|
|Subject: Re: query question |