SQL

alter table add multiple columns postgresql

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

postgres update multiple columns

UPDATE table_name 
SET column_one = TRUE,
    column_two = 'some string',
    column_three = 558,
WHERE column_four = 'some other string'

update multiple columns in postgres

postgres=# update sales 
           set order_date='2020-12-04', 
               amount=250 where id=3;

postgres=# select * from sales;
id | order_date | amount
----+------------+--------
1 | 2020-12-01 | 100
2 | 2020-12-02 | 250
3 | 2020-12-04 | 250
UPDATE 1