postgres default schema code example

Example 1: postgres set 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;