/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

4 votes326 views1 answer
Ms sql truncate table vs delete
SQL
0 vote296 views4 answers
Convert databse to achieve log mode oracle
SQL
1 vote267 views2 answers
How to drop a unique constraint in sql
SQL
1 vote289 views1 answer
Data type and their numeric form
SQL
2 votes274 views1 answer
Sqlite indexes
SQL
0 vote322 views1 answer
Mysql delete entire row on condition
SQL
0 vote342 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
2 votes268 views1 answer
Oracle sql query to make column data uppercase
SQL
1 vote330 views1 answer
Default
SQL
0 vote283 views1 answer
Sqlite higher or equal
SQL