↑↓ 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 7.4 reached end of support in October 2010. See the current version for supported releases.
PostgreSQL 7.4.30 Documentation
Prev Fast Backward Chapter 32. The Information Schema Fast Forward Next

32.17. enabled_roles

The view enabled_roles identifies all groups that the current user is a member of. (A role is the same thing as a group.) The difference between this view and applicable_roles is that in the future there may be a mechanism to enable and disable groups during a session. In that case this view identifies those groups that are currently enabled.

Table 32-15. enabled_roles Columns

Name Data Type Description
role_name sql_identifier Name of a group
Prev Home Next
element_types Up key_column_usage

Report a documentation issue

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