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

The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all

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

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

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

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

The catalog pg_event_trigger stores event triggers. See Chapter 38 for more information.

The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server

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

The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current