Here’s how to do it:
1 |
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:
1 |
ALTER ROLE myuser IN DATABASE mydb SET search_path = myschema; |
The same syntax works for any configuration parameter, such as localization parameters.