/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

2 votes247 views5 answers
Unique in sql server
SQL
0 vote131 views1 answer
Oracle list user locked
SQL
0 vote115 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote126 views1 answer
Mysql average from two table
SQL
0 vote130 views1 answer
How to create a table in sql stack overflow
SQL
0 vote136 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote114 views1 answer
Oracle sql developer closed connection
SQL
8 votes129 views1 answer
Check mysql version phpmyadmin
SQL
0 vote134 views1 answer
Snowflake drop column
SQL
0 vote116 views1 answer
Cross apply top for each row t1
SQL

Share