set default postgres table code example

Example 1: postgresql change default value

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

Example 2: postgres set default schema

SET search_path TO schema_name;