↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4
Historical version. PostgreSQL 8.0 reached end of support in October 2010. See the current version for supported releases.
PostgreSQL 8.0.26 Documentation
Prev Fast Backward Chapter 30. The Information Schema Fast Forward Next

30.4. applicable_roles

The view applicable_roles identifies all groups that the current user is a member of. (A role is the same thing as a group.) Generally, it is better to use the view enabled_roles instead of this one; see also there.

Table 30-2. applicable_roles Columns

Name Data Type Description
grantee sql_identifier Always the name of the current user
role_name sql_identifier Name of a group
is_grantable character_data Applies to a feature not available in PostgreSQL
Prev Home Next
information_schema_catalog_name Up check_constraints

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.