postgresql9..3 alter table add column with set default value code example

Example: postgresql change default value

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