/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 vote308 views1 answer
Joins vs includes
SQL
1 vote310 views2 answers
Select only columns that are not empty oracle sql
SQL
1 vote306 views1 answer
User privileges postgresql information_schema
SQL
0 vote314 views1 answer
How to use select union and loop
SQL
0 vote683 views1 answer
Sql field equals multiple values
SQL
10 votes305 views2 answers
Reset mysql root password mac
SQL
0 vote342 views2 answers
Get item by composite primary key mysql
SQL
1 vote339 views1 answer
Base64 encode sql server
SQL
0 vote298 views1 answer
Take sql dump in to file
SQL
0 vote346 views2 answers
Unique key
SQL