postgres set default value while creating column code example Example: postgres set default value ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';