/SQL/Postgres how to add field created at

Postgres how to add field created at

Postgresql add column with constraint

ALTER TABLE customers 
ADD COLUMN contact_name VARCHAR NOT NULL;

31

Source: postgresqltutorial.com

Postgres how to add field created at

CREATE TABLE my_table
(
	id serial NOT NULL,
    user_name text,
	created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP //here
)

2

Similar codes

13 votes364 views6 answers
Mysql update from select
SQL
0 vote362 views1 answer
Azure sql server check foreign key
SQL
0 vote356 views1 answer
Varchar format not case sensitive sql
SQL
0 vote462 views1 answer
Delet all record statment sql
SQL
0 vote357 views1 answer
How to input data as id in database sql c#
SQL
0 vote370 views3 answers
Duplicate row mysql
SQL
0 vote354 views1 answer
Change schema of all tables postgres
SQL
6 votes388 views2 answers
Mysqldump password in file
SQL
23 votes374 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote377 views1 answer
Savepoint mysql script
SQL

Share