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	May 27, 2013 22:17:00
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 Re: search_path for database vs user vs session
List	pgsql-general

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

From: Moshe Jacobson
Date: 27 May 2013, 22:07:37
Subject: Re: search_path for database vs user vs session

From: Joe Conway
Date: 27 May 2013, 22:50:23
Subject: Re: search_path for database vs user vs session