ALTER ADD COLUMN AND SET DEFAULT VALUE psql code example

Example: postgres set default value

ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';