create column for auto-date in postgresql

Question

I know that to create a column in mysql is like this

 'date' timestamp not null default CURRENT_TIMESTAMP,

how to postgresql?

What did you try so far? And what error message did you get, if you got one... — Frank Heikens
– Frank Heikens, Commented May 7, 2014 at 13:01
Apart from the invalid identifier for the column name, that looks OK to me. — user330315
– user330315, Commented May 7, 2014 at 13:04
To clarify, 'single quotes' represent a literal string; to quote an identifier, you need "double quotes": "date" timestamp not null default CURRENT_TIMESTAMP (or give your column a non-reserved name). — IMSoP
– IMSoP, Commented May 7, 2014 at 13:36

Craig Ringer · Accepted Answer · 2014-05-07 14:29:57Z

24

It's the same, you just have to fix the identifier quoting to use SQL standard "identifer quoting":

 "date" timestamp not null default CURRENT_TIMESTAMP,

but really, you should not use "date" as an identifier.

answered May 7, 2014 at 14:29

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1