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

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

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

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_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server

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

The view pg_stats provides access to the information stored in the

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_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the

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