The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows

The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication

The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search

The pg_ts_config_map catalog contains entries showing which text search dictionaries should be consulted, and in what order, for each output

The view pg_indexes provides access to useful information about each index in the database.

The catalog pg_rewrite stores rewrite rules for tables and views. Table 50-41

The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular

The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but

The catalog pg_language registers languages in which you can write functions or stored procedures. See

The view pg_matviews provides access to useful information about each materialized view in the database.