/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 vote336 views1 answer
Create temporal table in sql
SQL
7 votes340 views3 answers
How to check table name in current database sql
SQL
0 vote347 views1 answer
Selecting Data in SQL - Select Data
SQL
1 vote358 views1 answer
Drop column if exists sql server
SQL
9 votes375 views3 answers
Postgres make sql dump
SQL
22 votes375 views4 answers
Mysql date_format
SQL
0 vote350 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote433 views1 answer
Plpgsql create function
SQL
0 vote333 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote348 views1 answer
Group_concat only returns one row
SQL