Re: [GENERAL] search_path for database vs user vs session

2013-05-28 Thread Moshe Jacobson
On Tue, May 28, 2013 at 2:41 AM, Jov wrote: > you can use the psql \drds command: Perfect! Just what I was looking for. Thanks Jov, and thanks to Joe Conway as well for a different solution. Moshe -- Moshe Jacobson Nead Werx, Inc. | Manager of Systems Engineering 2323 Cumberland Parkway, Su

Re: [GENERAL] search_path for database vs user vs session

2013-05-27 Thread Jov
you can use the psql \drds command: \drds [PATRN1 [PATRN2]] list per-database role settings Jov blog: http:amutu.com/blog 2013/5/28 bricklen > > On Mon, May 27, 2013 at 12:16 PM, Moshe Jacobson wrote: > >> Oh, and I'd also like to see the current setting of the dat

Re: [GENERAL] search_path for database vs user vs session

2013-05-27 Thread bricklen
On Mon, May 27, 2013 at 12:16 PM, Moshe Jacobson 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-sett

Re: [GENERAL] search_path for database vs user vs session

2013-05-27 Thread Joe Conway
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/27/2013 12:16 PM, Moshe Jacobson wrote: > On Mon, May 27, 2013 at 3:07 PM, Moshe Jacobson > mailto:mo...@neadwerx.com>> wrote: > > I'd like to know how to see the search_path setting attached to a > particular user/role independent of the sessi

Re: [GENERAL] search_path for database vs user vs session

2013-05-27 Thread Moshe Jacobson
On Mon, May 27, 2013 at 3:07 PM, Moshe Jacobson 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.

Re: [GENERAL] search_path for database vs user vs session

2013-05-27 Thread Moshe Jacobson
On Mon, May 27, 2013 at 2:47 PM, Adrian Klaver 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/function

Re: [GENERAL] search_path for database vs user vs session

2013-05-27 Thread Adrian Klaver
On 05/27/2013 11:29 AM, Moshe Jacobson wrote: How can I show the value of search_path for the database, the user and the session? I ask because I cannot explain the following: $ psql -U postgres -d ises psql (9.1.4) Type "help" for help. postgres@moshe=>devmain:ises=# show searc