/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

7 votes148 views1 answer
Query postgres delete duplicates
SQL
0 vote148 views2 answers
Identity column in sql server
SQL
0 vote152 views3 answers
Sql query checker
SQL
0 vote138 views1 answer
Sql server manager close connection
SQL
2 votes150 views2 answers
Mysql show table column comments sql
SQL
0 vote141 views1 answer
MySQL error code 2068
SQL
0 vote143 views1 answer
Change role postgres
SQL
0 vote176 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
6 votes137 views2 answers
Mysql concatenate two columns into one
SQL
0 vote144 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL