How do I change column default value in PostgreSQL? October 20, 2022 by Tarik ‘SET’ is forgotten ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';