Is it possible to set current time as default value in a column with data type time in PostgreSQL?

user_5710696 0
Viewed 86

I was trying to create a column with data type time and trying to set the default value as the current time using HeidiSql. Below is the altered code.

ALTER TABLE "user"
    ADD "user" TIME NULL DEFAULT CURRENT_TIME();

But it output an error as below.

syntax error at or near ")"
LINE 2:  ADD "created_time" TIME NULL DEFAULT CURRENT_TIME()

Any idea about my mess?

postgresql sql
1 Answers

This works fine:

create table users (user_id serial);

ALTER TABLE users
    ADD create_Time TIME NULL DEFAULT CURRENT_TIME;

You don't need parentheses around CURRENT_TIME.

Some other things:

  • The error in your question is not generated by the SQL in the question; the column names are different.
  • It is highly unusual to put the time in without the date. Are you sure you don't want now()/CURRENT_TIMESTAMP?
  • Don't use escapes around names. They are just cumbersome to read and clunky to write.
user_11440350
Related