/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

3 votes177 views2 answers
Having in mysql
SQL
7 votes182 views1 answer
Sql server convert string to date
SQL
0 vote200 views1 answer
Sql check for null and empty string
SQL
0 vote181 views3 answers
Sql delete all except
SQL
2 votes186 views1 answer
Oracle list duplicates
SQL
0 vote190 views1 answer
Oracle merge insert if not exists
SQL
1 vote193 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
3 votes191 views2 answers
Mysql create timestamp column
SQL
0 vote188 views1 answer
Example of sql querry result sepapreted by comma
SQL
3 votes188 views1 answer
Oracle list privileges
SQL

Share