/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

3 votes172 views5 answers
Foreign keys
SQL
1 vote199 views1 answer
Oracle previous year
SQL
0 vote150 views1 answer
Postpresql relation not found
SQL
8 votes161 views2 answers
Oracle undo usage
SQL
7 votes159 views3 answers
Sql set
SQL
0 vote107 views2 answers
Postgresql could not start server mac
SQL
0 vote151 views1 answer
Stored procedures example
SQL
1 vote143 views1 answer
How to see logical reads in sql server
SQL
1 vote159 views1 answer
Mysql select update same table
SQL
2 votes173 views1 answer
Sql string starts with
SQL

Share