Postgres Pro
Downloads
Home   >   mailing lists

Re: search_path for database vs user vs session - Mailing list pgsql-general

From Jov
Subject Re: search_path for database vs user vs session
Date
Msg-id CADyrUxNg0R1eRtuWUcrpamjX7aiu4JXD=VT3Xp=rBu+evmRdsg@mail.gmail.com
Whole thread Raw
In response to Re: search_path for database vs user vs session  (bricklen <bricklen@gmail.com>)
Responses Re: search_path for database vs user vs session  (Moshe Jacobson <moshe@neadwerx.com>)
List pgsql-general
Tree view
you can use the psql  \drds command:

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






2013/5/28 bricklen <bricklen@gmail.com>

On Mon, May 27, 2013 at 12:16 PM, Moshe Jacobson <moshe@neadwerx.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



pgsql-general by date:

Previous
From: Amit Langote
Date:
Subject: Re: How to check if Postgresql files are OK
Next
From: image
Date:
Subject: 2 postgresql server on the same station : conflict?