/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 vote259 views2 answers
Procedure pl/sql
SQL
1 vote300 views1 answer
Date_part mysql
SQL
1 vote272 views1 answer
Sql server reseed single table
SQL
9 votes271 views1 answer
Identity insert on sql server
SQL
2 votes260 views1 answer
Select sid oracle
SQL
0 vote316 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
2 votes280 views1 answer
Check isolation level in mysql
SQL
0 vote299 views1 answer
Lost connection to mysql
SQL
-1 vote289 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
2 votes327 views2 answers
Create table mysql integer NOT null
SQL

Share