/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 vote153 views1 answer
Oracle query to find schema you are working on
SQL
6 votes164 views2 answers
Insert into select mysql
SQL
-2 votes155 views1 answer
Modify column name in tsql
SQL
1 vote163 views1 answer
Psql connect to another database
SQL
7 votes132 views1 answer
Forge server hosting
SQL
10 votes155 views2 answers
Forgot my mysql password mac
SQL
0 vote138 views1 answer
Postgres set default schema
SQL
0 vote146 views1 answer
How to order result of subquery in select
SQL
1 vote144 views1 answer
Delete mysql from mac
SQL
3 votes128 views1 answer
Oracle failed login attempts
SQL

Share