/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 vote114 views1 answer
Sql string length postgresql
SQL
0 vote128 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
1 vote132 views1 answer
Error code 1292 mysql workbench
SQL
1 vote136 views5 answers
What is in operator in sql
SQL
0 vote149 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
4 votes160 views6 answers
Select sql
SQL
0 vote90 views1 answer
Mysql timeout 30 seconds
SQL
4 votes126 views4 answers
Oracle tablespace tables list
SQL
0 vote123 views1 answer
How to check replication lag in mySQL
SQL
0 vote124 views1 answer
Oracle job class
SQL

Share