postgres 9.3

From: Ramesh T <rameshparnanditech(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: postgres 9.3
Date: 2015-09-19 08:36:48
Message-ID: CAK8Zd=uG+Eu0RKCLG-tsiNDRziO6apZQhZMSPby68UoXYcHKkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message FarjadFarid(ChkNet) 2015-09-19 18:31:53 Multiple insert
Previous Message David Steele 2015-09-18 21:40:59 Re: Broken primary key after backup restore.