Re: search_path for database vs user vs session

From: Jov <amutu(at)amutu(dot)com>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: Moshe Jacobson <moshe(at)neadwerx(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: search_path for database vs user vs session
Date: 2013-05-28 06:41:43
Message-ID: CADyrUxNg0R1eRtuWUcrpamjX7aiu4JXD=VT3Xp=rBu+evmRdsg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

you can use the psql \drds command:

\drds [PATRN1 [PATRN2]] list per-database role settings

Jov
blog: http:amutu.com/blog <http://amutu.com/blog>

2013/5/28 bricklen <bricklen(at)gmail(dot)com>

>
> On Mon, May 27, 2013 at 12:16 PM, Moshe Jacobson <moshe(at)neadwerx(dot)com>wrote:
>
>> Oh, and I'd also like to see the current setting of the database so I
>> know what will happen if I clear the user setting.
>
>
> I think you can find some of what you are looking for here:
> http://www.postgresql.org/docs/9.2/static/view-pg-settings.html
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message image 2013-05-28 09:54:17 2 postgresql server on the same station : conflict?
Previous Message Amit Langote 2013-05-28 06:28:14 Re: How to check if Postgresql files are OK