The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database combination. Unlike most system catalogs, pg_db_role_setting is shared across all databases of a cluster: there is only one copy of pg_db_role_setting per cluster, not one per database. Table 50-16. pg_db_role_setting Columns Name Type References Description setdatabase oid pg_database.oid The OID of the database the setting is applicable to, or zero if

The catalog pg_conversion describes encoding conversion procedures. See CREATE CONVERSION for more information. Table 50-14. pg_conversion Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly selected) conname name Conversion name (unique within a namespace) connamespace oid pg_namespace.oid The OID of the namespace that contains this conversion conowner oid pg_authid.oid Owner of the conversion conforencoding int4 Source encoding ID cont

The catalog pg_database stores information about the available databases. Databases are created with the CREATE DATABASE command. Consult Chapter 22 for details about the meaning of some of the parameters. Unlike most system catalogs, pg_database is shared across all databases of a cluster: there is only one copy of pg_database per cluster, not one per database. Table 50-15. pg_database Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly sel

The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories. See Section 23.2 for more information. Table 50-12. pg_collation Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly selected) collname name Collation name (unique per namespace and encoding) collnamespace oid pg_namespace.oid The OID of the namespace that contains this collation collowner oid

The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL. It is intended, for example, to be used by software packages that want to interface to PostgreSQL to facilitate finding the required header files and libraries. It provides the same basic information as the pg_config PostgreSQL client application. By default, the pg_config view can be read only by superusers. Table 50-61. pg_config Columns Name Type Description name text Th

The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but see also pg_index), sequences, views, materialized views, composite types, and TOAST tables; see relkind. Below, when we mean all of these kinds of objects we speak of "relations". Not all columns are meaningful for all relation types. Table 50-11. pg_class Columns Name Type References Description oid oid Row identifier (hidden attribute; must be expl

The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row for every column in every table in the database. (There will also be attribute entries for indexes, and indeed all objects that have pg_class entries.) The term attribute is equivalent to column and is used for historical reasons. Table 50-7. pg_attribute Columns Name Type References Description attrelid oid pg_class.oid The table this column belongs to attname name The column name at

The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed. Because user identities are cluster-wide, pg_auth_members is shared across all databases of a cluster: there is only one copy of pg_auth_members per cluster, not one per database. Table 50-9. pg_auth_members Columns Name Type References Description roleid oid pg_authid.oid ID of a role that has a member member oid pg_authid.oid ID of a role that is a member of roleid gr

The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the pg_extension catalog, which shows the extensions currently installed. Table 50-60. pg_available_extension_versions Columns Name Type Description name name Extension name version text Version name installed bool True if this version of this extension is currently installed superuser bool True if only superusers are allowed to install this extension relocatable bool T

The pg_available_extensions view lists the extensions that are available for installation. See also the pg_extension catalog, which shows the extensions currently installed. Table 50-59. pg_available_extensions Columns Name Type Description name name Extension name default_version text Name of default version, or NULL if none is specified installed_version text Currently installed version of the extension, or NULL if not installed comment text Comment string from the extension's control file