/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

0 vote344 views2 answers
Execute stored procedure without db set
SQL
29 votes309 views6 answers
Delete all rows from table mysql
SQL
1 vote323 views1 answer
Mysql select for update ejemplo
SQL
0 vote324 views2 answers
Mysql on update current_timestamp
SQL
1 vote366 views1 answer
How to set up a trigger in sql
SQL
2 votes341 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote306 views1 answer
Oracle job schedules
SQL
4 votes389 views2 answers
Delete all table oracle
SQL
0 vote327 views2 answers
How to login to mysql as normal user in ubuntu
SQL
5 votes300 views1 answer
Migrate sql table another database
SQL

Share