Set Default Search Path

      Using alter command we can set the user default search path.

Syntax:
ALTER USER <User Name> SEARCH_PATH <Schema Name>, "$user", public;

Example:
ALTER USER sample_user SEARCH_PATH test_schema, "$user", public;


See also:

•  User creation
• Grant usage on schema public
• Create Schema
• Grant usage privileges on a schema to the user
• Grant all privileges on a schema to the user