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.
