Carol Walter <walterc(at)indiana(dot)edu> writes:
> We recently began giving our users a ten connection limit. The are
> some accounts that have no limit. Some of these should have no limit
> because they're system accounts, but others are just users that were
> created before we started the limit. Is there a psql command that I
> can run with a "where" clause that will let me get a list of everyone
> who has no connection limit?
Sure, look into pg_authid for negative rolconnlimit entries.
regards, tom lane