/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 vote374 views1 answer
Postgresql linux password
SQL
0 vote361 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
1 vote382 views1 answer
T-SQL / AZURE Reseed
SQL
2 votes385 views1 answer
Dbms transaction (psql)
SQL
0 vote421 views1 answer
Remove mysql from centos 7
SQL
7 votes372 views4 answers
Mysql delete older duplicates
SQL
3 votes334 views1 answer
Delete all content in table mysql
SQL
0 vote345 views1 answer
Update database collation in postgresql
SQL
1 vote341 views1 answer
Local sql server
SQL
1 vote338 views1 answer
Adding a default constraint to an existing column in sql
SQL