The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of

The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their

The catalog pg_trigger stores triggers on tables and views. See CREATE

The catalog pg_index contains part of the information about indexes. The rest is mostly in pg_class.

The pg_available_extensions view lists the extensions that are available for installation. See also the

The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48.

The view pg_locks provides access to information about the locks held by active processes within the database server. See Chapter 13 for more

The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently

In addition to the system catalogs, PostgreSQL provides a number of built-in views. Some system views provide convenient access to some commonly

The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that