/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 vote202 views2 answers
Sql trigger difference between for and after
SQL
2 votes196 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote194 views2 answers
ImportError: No module named mysql.connector
SQL
1 vote176 views1 answer
Update from select join
SQL
1 vote188 views1 answer
Crontab every month
SQL
1 vote176 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote221 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
1 vote214 views1 answer
How to set up a trigger in sql
SQL
0 vote197 views1 answer
Gcloud check sql
SQL
3 votes198 views2 answers
How to start postgresql on windows
SQL

Share