/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

4 votes99 views2 answers
Mysql delete user if exists
SQL
1 vote119 views1 answer
Oracle sql pad left zeros
SQL
1 vote97 views3 answers
Remove unique key from a table
SQL
1 vote114 views1 answer
Psql import backup file for windows
SQL
0 vote102 views1 answer
Find number of entries sql
SQL
1 vote131 views3 answers
Postgresql crete view
SQL
4 votes116 views4 answers
Check constraint in ms sql
SQL
1 vote94 views1 answer
Sql Split string function
SQL
6 votes96 views1 answer
Phpmyadmin reset root password
SQL
0 vote132 views1 answer
Sql to excel pgadmin
SQL