Stephen Frost wrote:
-- Start of PGP signed section.
> Bruce, et al,
>
> * Bruce Momjian (bruce@momjian.us) wrote:
> > \dg [PATTERN] list roles (groups)
> > \du [PATTERN] list roles (users)
>
> Seeing this list reminded me of a pet-peeve.. \du and \dg actually show
> the same info, that's fine, but neither of them show the rolcanlogin
> value. As someone who has a bad habit of doing 'create role blah;' for
> new users this can get very annoying. I also have people complain to me
> that they can't figure out why a new user can't log in after they did
> the same thing. Could we get that changed? Or maybe have 'connections'
> say something different when you don't have rolcanlogin besides 'no
> limit'?
\du/\dg shows the "Cannot login" specification, which I think is
sufficient.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +