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

Table 50-1 lists the system catalogs. More detailed documentation of each catalog follows below. Most system catalogs are copied from the template

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

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

The catalog pg_operator stores information about operators. See CREATE

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

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

The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection

The catalog pg_largeobject holds the data making up "large objects". A large object is identified by an OID assigned

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