Readers,
A csv file contains data with date and time values in format dd/mm/yy hh:mm:
number,date time,text
So the CREATE command was used:
CREATE TABLE tablename (number int,timestamp,text varchar(150));
ERROR: syntax error at or near ","
LINE 1: CREATE TABLE tablename (number int,timestamp,text varchar(1...
The command SHOW DATESTYLE shows:
SHOW DATESTYLE;
DateStyle
-----------
ISO, DMY
(1 row)
What is my error to prevent import of the date and time values please?