Re: search_path for database vs user vs session

[Moshe Jacobson <moshe@xxxxxxxxxxxx>]

On Mon, May 27, 2013 at 2:47 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:

Is the below what you are looking for?

http://www.postgresql.org/docs/9.2/static/runtime-config-client.html

http://www.postgresql.org/docs/9.2/static/functions-info.html

Adrian,

I'd like to know how to see the search_path setting attached to a particular user/role independent of the session.

Thanks.

--

Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering

2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@xxxxxxxxxxxx | www.neadwerx.com

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