cnahnge type and default of column postgres code example Example: postgresql change default value ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';