Re: [pgsql-novice] Daily digest v1.2917 (11 messages) - Mailing list pgsql-novice

From e-letter
Subject Re: [pgsql-novice] Daily digest v1.2917 (11 messages)
Date
Msg-id BANLkTimXzd3SpeYx+phJ=fURZg3A0ZmF=w@mail.gmail.com
Whole thread Raw
Responses Re: [pgsql-novice] Daily digest v1.2917 (11 messages)
List pgsql-novice
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?

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: after update trigger ?
Next
From: Vibhor Kumar
Date:
Subject: Re: [pgsql-novice] Daily digest v1.2917 (11 messages)