How to add column if not exists on PostgreSQL?

October 19, 2022 by Tarik

With Postgres 9.6 this can be done using the option if not exists

ALTER TABLE table_name ADD COLUMN IF NOT EXISTS column_name INTEGER;