/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

7 votes205 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote265 views1 answer
Get initials name in sql
SQL
0 vote226 views1 answer
Sql select lowest value row
SQL
0 vote200 views1 answer
Date on SQL
SQL
9 votes213 views6 answers
Check constraint in sql
SQL
0 vote239 views2 answers
Mysql add days to date
SQL
0 vote208 views1 answer
Compare if is null sql
SQL
1 vote217 views1 answer
Replace all numbers in mysql
SQL
2 votes215 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote191 views1 answer
Acutal month year
SQL

Share