/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 vote240 views1 answer
Sql server synonym
SQL
-1 vote215 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
3 votes201 views1 answer
Oracle sleep
SQL
2 votes222 views1 answer
Sql find not in list
SQL
1 vote204 views1 answer
Md5 encryption for existing records
SQL
1 vote222 views1 answer
Sql list all procedures
SQL
0 vote205 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote208 views2 answers
Zsh: command not found: mysq
SQL
0 vote310 views1 answer
Get statis values sql
SQL
5 votes272 views3 answers
Create function in postgresql
SQL