Re: postgres 9.3

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 <rameshparnanditech(at)gmail(dot)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.