/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

1 vote331 views1 answer
Mysql batch insert
SQL
0 vote368 views1 answer
Python sql last insertend
SQL
4 votes316 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
1 vote387 views1 answer
Oracle show execution plan
SQL
4 votes350 views4 answers
Start mysql
SQL
0 vote564 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote327 views1 answer
PSQL qith variables
SQL
0 vote404 views1 answer
Différence entre deux dates sql oracle
SQL
5 votes336 views2 answers
Copy data from one database to another
SQL
0 vote324 views1 answer
Rabbitmq service not starting
SQL