The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories

The pg_prepared_statements view displays all the prepared statements that are available in the current session. See

The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the

The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL

The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the

The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values

The view pg_seclabels provides information about security labels. It as an easier-to-query version of the

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

The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all

The view pg_stats provides access to the information stored in the