you can use the psql \drds command: \drds [PATRN1 [PATRN2]] list per-database role settings
Jov blog: http:amutu.com/blog <http://amutu.com/blog> 2013/5/28 bricklen <brick...@gmail.com> > > On Mon, May 27, 2013 at 12:16 PM, Moshe Jacobson <mo...@neadwerx.com>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 > > >