Thread: Re: [pgsql-novice] Daily digest v1.2917 (11 messages)
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?
On Apr 23, 2011, at 1:10 PM, e-letter wrote: > > 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... You forgot to mention the columnname for timestamp: > CREATE TABLE tablename (number int, <columnname> timestamp,text varchar(150)); Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.kumar@enterprisedb.com Blog:http://vibhork.blogspot.com