/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 vote167 views1 answer
Mysql undo delete
SQL
0 vote193 views1 answer
Sql requete number pair
SQL
0 vote210 views1 answer
Postgres docs /copy metacomand
SQL
1 vote181 views1 answer
Blob datatype in mysql
SQL
103 votes561 views2 answers
Sql server LIKE '%%'
SQL
0 vote204 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
5 votes229 views1 answer
How to get all table names in sql query
SQL
0 vote199 views1 answer
Sql alter table order by
SQL
0 vote175 views1 answer
Mysql foreach insert
SQL
16 votes181 views2 answers
Add column if not exists mysql
SQL