DBA Hub

📋Steps in this guide1/1

Set search_path of a user in postgres

-- set search_path for a user in particular db:

postgresql configurationintermediate
by PostgreSQL
14 views
1

Set search_path of a user in postgres

Code/Command (click line numbers to comment):

1
2
3
4
5
6
-- set search_path for a user in particular db:
postgres#
alter user prod_user in database "EDB" set search_path="$user", public, prim_db;
-- set search_path for a user in postgres cluster( all dbs)
postgres=#
alter user prod_user set search_path="$user", public, prim_db;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!