I have one database and two schemas in that public,preview and role preview
automatically i want to connect preview schema with preview role.
set search_path to preview.
show search_path;
..
preview.
when disconnect and connect database it's showing $user$:public schema not showing preview.
what is the problem..?how to resolve the issue...?
when session closed showing postgres user..even set preview.