/SQL/Postgresql create table default value timestamp

Postgresql create table default value timestamp

CREATE TABLE `table_name`(
	`id` SERIAL PRIMARY KEY,
	`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`modified_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
)

Similar codes

6 votes141 views1 answer
Identify primary key in oracle table
SQL
4 votes134 views1 answer
Sql delete multiple conditions
SQL
7 votes152 views1 answer
Sql limit decimal places
SQL
1 vote138 views2 answers
Maximum number of tables in mysql
SQL
0 vote138 views1 answer
What does leave do in mysql
SQL
0 vote144 views1 answer
Providername system.data. mysql
SQL
1 vote138 views3 answers
Mysql connection string
SQL
1 vote129 views1 answer
Group_concat max length mysql
SQL
1 vote130 views3 answers
Sql server get week dates from week number
SQL
4 votes186 views2 answers
Sql select except null
SQL