How to Add a Column in PostgreSQL

This example adds the column my_new_column of type TEXT to the existing table my_table:

ALTER TABLE my_table
ADD COLUMN my_new_column TEXT;

Adding multiple columns

You can also add multiple new columns at once:

ALTER TABLE my_table
ADD COLUMN my_new_column_1 TEXT,
ADD COLUMN my_new_column_2 BOOLEAN;