Bruce Hyatt <brucejhyatt@yahoo.com> writes:
> It appears there are some predefined roles (superuser, admin) but I
> can't find a definition of these privileges in the documentation.
There's no builtin concept of an "admin" role. There is such a thing as
superuser, but that's a property of a role not a specific role (ie, you
can have more than one superuser role if you want). See "Database roles
and privileges" chapter in the manual. The CREATE ROLE reference page
has some details too. Be sure to consult the manual version
corresponding to the PG version you are using, as the features in this
area have changed over time.
regards, tom lane