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]
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@xxxxxxxxx> wrote:
I have one database and two schemas in that public,preview and role previewautomatically 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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
