The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each

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_views provides access to useful information about each view in the database.

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

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

The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement

The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning

The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each

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