/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

1 vote337 views1 answer
Loading local data is disabled mysql
SQL
0 vote359 views1 answer
Sql period overlap
SQL
21 votes332 views6 answers
Docker run mysql
SQL
0 vote328 views1 answer
Get time component of datetime sql
SQL
0 vote379 views1 answer
Sql query to get contact form 7 fields
SQL
10 votes369 views4 answers
Else if mysql
SQL
0 vote377 views1 answer
Oracle last connexion
SQL
0 vote338 views1 answer
SqlFunction does not exist
SQL
93 votes476 views4 answers
Create database postgres
SQL
8 votes387 views2 answers
How to fetch data from database without last column
SQL

Share