/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

12 votes170 views4 answers
Mysql get date difference in hours
SQL
0 vote248 views1 answer
Osm2pgsql mac
SQL
1 vote196 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote230 views1 answer
Find duplicate users by email address in mysql
SQL
6 votes177 views2 answers
Oracle
SQL
0 vote174 views1 answer
Check sql database table lock
SQL
0 vote181 views1 answer
Sql trying to delete database in use
SQL
0 vote174 views1 answer
How to find username and password in oracle 18c
SQL
1 vote196 views1 answer
Sql first day quarter
SQL
0 vote182 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL

Share