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