postgres switch value multiple columns code example

Example 1: postgresql combine values in one field

SELECT movie, string_agg(actor, ', ') AS actor_list
FROM   tbl
GROUP  BY 1;

Example 2: alter table add multiple columns postgresql

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