/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 votes453 views1 answer
Oracle nextval insert
SQL
1 vote342 views1 answer
Sql server update column based on another table
SQL
0 vote333 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
3 votes418 views3 answers
Update con select postgresql
SQL
0 vote354 views1 answer
Insert output identity
SQL
0 vote452 views1 answer
Run docker container with database as rds metabase
SQL
0 vote357 views1 answer
Select in select sql
SQL
6 votes345 views2 answers
Return columns from table sql
SQL
19 votes343 views2 answers
Mysql add column after another
SQL
0 vote344 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL

Share