Mikko Kortelainen

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.

Rate this article
💬 Leave a comment