Search PostgreSQL documentation

pg_stat_activityCatalogs & ViewsReferencepg_stat_activity Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in Tabl…System Catalogs · Statistics views pg_aggregateCatalogs & ViewsReferencepg_aggregate System catalogs 10 The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values (typically one col…System Catalogs · System catalogs pg_aiosCatalogs & ViewsReferencepg_aios System views 18 The pg_aios view lists all Asynchronous I/O handles that are currently in-use. An I/O handle is used to reference an I/O operation that is being prepared, executed or…System Catalogs · System views pg_amCatalogs & ViewsReferencepg_am System catalogs 10 The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently, only indexes have acc…System Catalogs · System catalogs pg_amopCatalogs & ViewsReferencepg_amop System catalogs 10 The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that is a member of an o…System Catalogs · System catalogs pg_amprocCatalogs & ViewsReferencepg_amproc System catalogs 10 The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each support procedure be…System Catalogs · System catalogs pg_attrdefCatalogs & ViewsReferencepg_attrdef System catalogs 10 The catalog pg_attrdef stores column default values. The main information about columns is stored in pg_attribute (see below). Only columns that explicitly spec…System Catalogs · System catalogs pg_attributeCatalogs & ViewsReferencepg_attribute System catalogs 10 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. (…System Catalogs · System catalogs pg_auth_membersCatalogs & ViewsReferencepg_auth_members System catalogs 10 The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed. Because user identities are cl…System Catalogs · System catalogs pg_authidCatalogs & ViewsReferencepg_authid System catalogs 10 The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of “users” and “groups”. A user is esse…System Catalogs · System catalogs pg_available_extension_versionsCatalogs & ViewsReferencepg_available_extension_versions System views 10 The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the pg_extension …System Catalogs · System views pg_available_extensionsCatalogs & ViewsReferencepg_available_extensions System views 10 The pg_available_extensions view lists the extensions that are available for installation. See also the pg_extension catalog, which shows the extensio…System Catalogs · System views pg_backend_memory_contextsCatalogs & ViewsReferencepg_backend_memory_contexts System views 14 The view pg_backend_memory_contexts displays all the memory contexts of the server process attached to the current session. pg_backend_memory_cont…System Catalogs · System views pg_castCatalogs & ViewsReferencepg_cast System catalogs 10 The catalog pg_cast stores data type conversion paths, both built-in and user-defined. It should be noted that pg_cast does not represent every type conversion th…System Catalogs · System catalogs pg_classCatalogs & ViewsReferencepg_class System catalogs 10 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), …System Catalogs · System catalogs pg_collationCatalogs & ViewsReferencepg_collation System catalogs 10 The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories. See Sectio…System Catalogs · System catalogs pg_configCatalogs & ViewsReferencepg_config System views 10 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 …System Catalogs · System views pg_constraintCatalogs & ViewsReferencepg_constraint System catalogs 10 The catalog pg_constraint stores check, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated specially.…System Catalogs · System catalogs pg_conversionCatalogs & ViewsReferencepg_conversion System catalogs 10 The catalog pg_conversion describes encoding conversion procedures. See CREATE CONVERSION for more information. oid Row identifier (hidden attribute; must be…System Catalogs · System catalogs pg_cursorsCatalogs & ViewsReferencepg_cursors System views 10 The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways: The pg_cursors view displays cursors created by any of…System Catalogs · System views pg_databaseCatalogs & ViewsReferencepg_database System catalogs 10 The catalog pg_database stores information about the available databases. Databases are created with the CREATE DATABASE command. Consult Chapter 22 for detail…System Catalogs · System catalogs pg_db_role_settingCatalogs & ViewsReferencepg_db_role_setting System catalogs 10 The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database combinatio…System Catalogs · System catalogs pg_default_aclCatalogs & ViewsReferencepg_default_acl System catalogs 10 The catalog pg_default_acl stores initial privileges to be assigned to newly created objects. oid Row identifier (hidden attribute; must be explicitly selec…System Catalogs · System catalogs pg_dependCatalogs & ViewsReferencepg_depend System catalogs 10 The catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dr…System Catalogs · System catalogs pg_descriptionCatalogs & ViewsReferencepg_description System catalogs 10 The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and vi…System Catalogs · System catalogs pg_dsm_registry_allocationsCatalogs & ViewsReferencepg_dsm_registry_allocations System views 19 The pg_dsm_registry_allocations view shows shared memory allocations tracked in the dynamic shared memory (DSM) registry. This includes memory all…System Catalogs · System views pg_enumCatalogs & ViewsReferencepg_enum System catalogs 10 The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is actually the OID of its…System Catalogs · System catalogs pg_event_triggerCatalogs & ViewsReferencepg_event_trigger System catalogs 10 The catalog pg_event_trigger stores event triggers. See Chapter 39 for more information. evtname Trigger name (must be unique) evtevent Identifies the eve…System Catalogs · System catalogs pg_extensionCatalogs & ViewsReferencepg_extension System catalogs 10 The catalog pg_extension stores information about the installed extensions. See Section 37.15 for details about extensions. oid Row identifier (hidden attribu…System Catalogs · System catalogs pg_file_settingsCatalogs & ViewsReferencepg_file_settings System views 10 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 “name = value” entry …System Catalogs · System views pg_foreign_data_wrapperCatalogs & ViewsReferencepg_foreign_data_wrapper System catalogs 10 The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residi…System Catalogs · System catalogs pg_foreign_serverCatalogs & ViewsReferencepg_foreign_server System catalogs 10 The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server. Foreign s…System Catalogs · System catalogs pg_foreign_tableCatalogs & ViewsReferencepg_foreign_table System catalogs 10 The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a pg_class entry, just like …System Catalogs · System catalogs pg_groupCatalogs & ViewsReferencepg_group System views 10 The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. It shows the names and members of all role…System Catalogs · System views pg_hba_file_rulesCatalogs & ViewsReferencepg_hba_file_rules System views 10 The view pg_hba_file_rules provides a summary of the contents of the client authentication configuration file, pg_hba.conf. A row appears in this view for e…System Catalogs · System views pg_ident_file_mappingsCatalogs & ViewsReferencepg_ident_file_mappings System views 15 The view pg_ident_file_mappings provides a summary of the contents of the client user name mapping configuration file, pg_ident.conf. A row appears in …System Catalogs · System views pg_indexCatalogs & ViewsReferencepg_index System catalogs 10 The catalog pg_index contains part of the information about indexes. The rest is mostly in pg_class. indexrelid The OID of the pg_class entry for this index indre…System Catalogs · System catalogs pg_indexesCatalogs & ViewsReferencepg_indexes System views 10 The view pg_indexes provides access to useful information about each index in the database. schemaname Name of schema containing table and index tablename Name of …System Catalogs · System views pg_inheritsCatalogs & ViewsReferencepg_inherits System catalogs 10 The catalog pg_inherits records information about table inheritance hierarchies. There is one entry for each direct child table in the database. (Indirect inhe…System Catalogs · System catalogs pg_init_privsCatalogs & ViewsReferencepg_init_privs System catalogs 10 The catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the database which…System Catalogs · System catalogs