Set Default search_path for a User in PostgreSQL
Here's how to do it:
ALTER ROLE myuser IN DATABASE mydb SET search_path = myschema;
The same syntax works for any configuration parameter, such as localization parameters.
Here's how to do it:
ALTER ROLE myuser IN DATABASE mydb SET search_path = myschema;
The same syntax works for any configuration parameter, such as localization parameters.