/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

11 votes229 views2 answers
You are using safe update mode
SQL
0 vote344 views1 answer
Multiple row join
SQL
2 votes274 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote222 views1 answer
How to login to mysql in homestead
SQL
38 votes248 views6 answers
Ubuntu install mysql client
SQL
0 vote208 views1 answer
Mysql command prompt date insert format
SQL
0 vote178 views1 answer
Mysqli or pdo
SQL
2 votes229 views2 answers
Postgres trigger insert into another table
SQL
0 vote214 views1 answer
Gcloud check sql
SQL
3 votes217 views1 answer
Ssh check mysql version
SQL

Share