Carol Walter <walterc@xxxxxxxxxxx> 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
