You cannot directly "connect" one schema with another, but you can set the default to have both in the search_path. Uncomment the #search_path parameter in Postgresql.conf and change it to search_path = 'preview, role,public,"$user",public'
The make sure you do: sudo su - postgres pg_ctl reload [-D datadir] On Sat, Sep 19, 2015 at 4:36 AM, Ramesh T <rameshparnandit...@gmail.com> wrote: > 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. > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.