/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 vote291 views1 answer
Mysql dump with table query
SQL
0 vote292 views3 answers
Postgres date difference seconds
SQL
0 vote258 views1 answer
Mysql two joins
SQL
4 votes282 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote282 views1 answer
Mysql user set plugin
SQL
1 vote222 views2 answers
Show sql logs in spring boot
SQL
0 vote271 views1 answer
Sql get date from timestamp
SQL
0 vote236 views1 answer
Mysql create table columns with spaces
SQL
0 vote252 views1 answer
Mysql max number not returning correct value
SQL
3 votes262 views2 answers
Postgresql remove not null constraint
SQL