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>
I think you can find some of what you are looking for here: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.
http://www.postgresql.org/docs/9.2/static/view-pg-settings.html