/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

2 votes203 views3 answers
Sql truncate table
SQL
0 vote207 views1 answer
Insert or update sql firebird
SQL
0 vote198 views1 answer
Sql change default collation to utf8
SQL
4 votes224 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
4 votes201 views2 answers
Postgre sql create table
SQL
0 vote191 views1 answer
Sql server inner join convert collation
SQL
0 vote205 views3 answers
Magento 2 order delete from db
SQL
-1 vote198 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
1 vote190 views1 answer
Mysql select month and year
SQL
5 votes784 views1 answer
Oracle ora-00054 find
SQL