Search Postgresql Archives

Re: search_path for database vs user vs session

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <bricklen@xxxxxxxxx>

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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux