/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 votes231 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote222 views1 answer
Alter table name including schema
SQL
0 vote229 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote221 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote248 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
1 vote229 views1 answer
How to test for sql injection
SQL
0 vote227 views1 answer
Oracle synonym procedure dblink
SQL
1 vote231 views1 answer
Check if mysql is installed
SQL
0 vote219 views1 answer
Recursive query herarchical data sql server
SQL
0 vote255 views2 answers
Oracle chain rules
SQL