/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 vote181 views2 answers
Mysql filter by date mount
SQL
0 vote183 views1 answer
Sqlite referential integrity
SQL
0 vote202 views1 answer
Savepoint mysql script
SQL
10 votes244 views2 answers
Reset mysql root password mac
SQL
1 vote193 views1 answer
Sqlite3 read only
SQL
22 votes192 views6 answers
Create sql table
SQL
5 votes187 views2 answers
Oracle tables with column name
SQL
0 vote179 views1 answer
Mysql export and import
SQL
3 votes171 views2 answers
Pl sql escape '
SQL
0 vote165 views1 answer
Trim sql oracle
SQL