Postgres Pro
Downloads
Home   >   mailing lists

postgres 9.3 - Mailing list pgsql-general

From Ramesh T
Subject postgres 9.3
Date
Msg-id CAK8Zd=uG+Eu0RKCLG-tsiNDRziO6apZQhZMSPby68UoXYcHKkQ@mail.gmail.com
Whole thread Raw
Responses Re: postgres 9.3
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Bushmelev Anton
Date:
Subject: Re: @ operator
Next
From: John Leiseboer
Date:
Subject: Memory for BYTEA returned by C function is not released until connection is dropped