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

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

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_locks provides access to information about the locks held by active processes within the database server. See Chapter 13 for more

The catalog pg_default_acl stores initial privileges to be assigned to newly created objects.

The view pg_roles provides access to information about database roles. This is simply a publicly readable view of

The catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the

The catalog pg_conversion describes encoding conversion procedures. See

The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in

The catalog pg_type stores information about data types. Base types and enum types (scalar types) are created with