/SQL/Postgresql insert column

Postgresql insert column

Postgresql add column with constraint

ALTER TABLE customers 
ADD COLUMN contact_name VARCHAR NOT NULL;

31

Source: postgresqltutorial.com

Postgresql insert column

ALTER TABLE table_name
ADD COLUMN new_column_name data_type constraint;

4

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

5 votes201 views1 answer
Sql use database
SQL
0 vote193 views2 answers
How to display enum value sql server
SQL
1 vote147 views1 answer
Pagination sql
SQL
4 votes208 views1 answer
Is there any command to change postgres password
SQL
3 votes191 views1 answer
Mysql set field unique
SQL
2 votes206 views6 answers
Mysql change timezone
SQL
4 votes209 views3 answers
Rename table column postgresql
SQL
0 vote233 views1 answer
Get from database the most recent data limit by 5
SQL
2 votes183 views1 answer
Mysql how to store lat,lng
SQL
1 vote215 views2 answers
Oracle 18c xe ORA-65096
SQL

Share