Postgres Pro
Downloads
Home   >   mailing lists

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

From Moshe Jacobson
Subject Re: search_path for database vs user vs session
Date
Msg-id CAJ4CxL=Hh9h2GQ1NbTWc9uJ1x+H9tXxGv7LvzcM5maG6oB7H=Q@mail.gmail.com
Whole thread Raw
In response to Re: search_path for database vs user vs session  (Moshe Jacobson <moshe@neadwerx.com>)
Responses Re: search_path for database vs user vs session  (Joe Conway <mail@joeconway.com>)
Re: search_path for database vs user vs session  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tree view
On Mon, May 27, 2013 at 3:07 PM, Moshe Jacobson <moshe@neadwerx.com> wrote:
I'd like to know how to see the search_path setting attached to a particular user/role independent of the session.

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.


--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle

pgsql-general by date:

Previous
From: Moshe Jacobson
Date:
Subject: Re: search_path for database vs user vs session
Next
From: Joe Conway
Date:
Subject: Re: search_path for database vs user vs session