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_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular

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

The catalog pg_attrdef stores column default values. The main information about columns is stored in pg_attribute

The view pg_rules provides access to useful information about query rewrite rules. Table

The catalog pg_inherits records information about table inheritance hierarchies. There is one entry for each direct child table in the database

The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

The catalog pg_database stores information about the available databases. Databases are created with the

The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser

The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row