postgres add column with default value on condition code example
Example 1: postgresql add column with constraint
ALTER TABLE customers
ADD COLUMN contact_name VARCHAR NOT NULL;
Example 2: postgres set default value
ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';