Question

How to add multiple columns in PostgreSQL

Answer 1

ALTER TABLE table_name
ADD COLUMN column_name1 data_type [constraints],
ADD COLUMN column_name2 data_type [constraints];

-- Example: 

ALTER TABLE users
ADD COLUMN user_status VARCHAR(20) DEFAULT 'Pending',
ADD COLUMN verified BOOLEAN DEFAULT FALSE,
ADD COLUMN user_role TEXT;

 

70+ SQL courses for beginners and professionals