/SQL/Postgres add column integer

Postgres add column integer

Alter table add multiple columns postgresql

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

2

Source: postgresqltutorial.com

Postgres add column integer

ALTER TABLE customers 
ADD COLUMN COUNT INTEGER NOT NULL;

0

Source: postgresqltutorial.com

Similar codes

4 votes307 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
5 votes305 views1 answer
Oracle asynchronous procedure
SQL
0 vote355 views2 answers
Oracle chain rules
SQL
4 votes310 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote271 views1 answer
Denied
SQL
0 vote330 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote327 views1 answer
Codeigniter 3 get best-selling products
SQL
19 votes334 views6 answers
Create table sqlite
SQL
0 vote326 views1 answer
How to drop a trigger in postgresql
SQL
2 votes356 views1 answer
Sql server find columns list in tables
SQL

Share