/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

0 vote169 views1 answer
Login failed for login due to trigger execution
SQL
1 vote200 views1 answer
Rows to comma separated values in mssql
SQL
4 votes178 views1 answer
List tables sqlite
SQL
0 vote169 views1 answer
Sql select most frequent value in group
SQL
0 vote173 views1 answer
Sql server select top 2 of each group
SQL
15 votes177 views2 answers
How to know the username of postgresql
SQL
1 vote194 views1 answer
Mysql print variable
SQL
22 votes170 views6 answers
Create sql table
SQL
0 vote188 views1 answer
Query params sql insert python f string
SQL
0 vote297 views2 answers
Create new table from existing table with data in sql server
SQL