/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 vote146 views1 answer
How to alter length character varying postgres
SQL
0 vote140 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote148 views1 answer
Postgres grep entire database
SQL
0 vote117 views1 answer
Sql examples from your work
SQL
0 vote130 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote146 views1 answer
Psql check table fields
SQL
0 vote130 views1 answer
Sql server cannot create database diagram
SQL
31 votes142 views2 answers
Grant all priviledges to mysql user
SQL
0 vote157 views1 answer
To Create directory
SQL
16 votes128 views2 answers
Add column to all tables after first column mysql
SQL