/SQL/PostgreSQL add column

PostgreSQL add 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

Alter table add multiple columns postgresql

        
            
        
     ALTER TABLE customer 
ADD COLUMN fax VARCHAR,
ADD COLUMN email VARCHAR;

3

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 vote145 views2 answers
On update cascade
SQL
0 vote200 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote288 views1 answer
Generate a random otp in sql server
SQL
2 votes153 views2 answers
Oracle multiple insert
SQL
1 vote107 views1 answer
Postgresql last element of array
SQL
0 vote154 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote155 views1 answer
Md5 encryption for existing records
SQL
4 votes146 views1 answer
Mysql insert from local csv
SQL
-1 vote162 views1 answer
What is in operator
SQL
1 vote156 views3 answers
Mysql disable foreign keys check
SQL

Share