Search PostgreSQL documentation

pg_languageCatalogs & ViewsReferencepg_language System catalogs 10 The catalog pg_language registers languages in which you can write functions or stored procedures. See CREATE LANGUAGE and Chapter 41 for more information abou…System Catalogs · System catalogs pg_largeobjectCatalogs & ViewsReferencepg_largeobject System catalogs 10 The catalog pg_largeobject holds the data making up “large objects”. A large object is identified by an OID assigned when it is created. Each large object i…System Catalogs · System catalogs pg_largeobject_metadataCatalogs & ViewsReferencepg_largeobject_metadata System catalogs 10 The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in pg_largeobject. oid Row…System Catalogs · System catalogs pg_locksCatalogs & ViewsReferencepg_locks System views 10 The view pg_locks provides access to information about the locks held by active processes within the database server. See Chapter 13 for more discussion of locking. …System Catalogs · System views pg_matviewsCatalogs & ViewsReferencepg_matviews System views 10 The view pg_matviews provides access to useful information about each materialized view in the database. schemaname Name of schema containing materialized view ma…System Catalogs · System views pg_namespaceCatalogs & ViewsReferencepg_namespace System catalogs 10 The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, t…System Catalogs · System catalogs pg_opclassCatalogs & ViewsReferencepg_opclass System catalogs 10 The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular data type and a par…System Catalogs · System catalogs pg_operatorCatalogs & ViewsReferencepg_operator System catalogs 10 The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.12 for more information. oid Row identifier (hidden attribute; m…System Catalogs · System catalogs pg_opfamilyCatalogs & ViewsReferencepg_opfamily System catalogs 10 The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement the semanti…System Catalogs · System catalogs pg_parameter_aclCatalogs & ViewsReferencepg_parameter_acl System catalogs 15 The catalog pg_parameter_acl records configuration parameters for which privileges have been granted to one or more roles. No entry is made for parameters…System Catalogs · System catalogs pg_partitioned_tableCatalogs & ViewsReferencepg_partitioned_table System catalogs 10 The catalog pg_partitioned_table stores information about how tables are partitioned. partrelid The OID of the pg_class entry for this partitioned tab…System Catalogs · System catalogs pg_pltemplateCatalogs & ViewsReferencepg_pltemplate System catalogs 10 The catalog pg_pltemplate stores “template” information for procedural languages. A template for a language allows the language to be created in a particular…System Catalogs · System catalogs pg_policiesCatalogs & ViewsReferencepg_policies System views 10 The view pg_policies provides access to useful information about each row-level security policy in the database. schemaname Name of schema containing table policy…System Catalogs · System views pg_policyCatalogs & ViewsReferencepg_policy System catalogs 10 The catalog pg_policy stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all commands), the roles …System Catalogs · System catalogs pg_prepared_statementsCatalogs & ViewsReferencepg_prepared_statements System views 10 The pg_prepared_statements view displays all the prepared statements that are available in the current session. See PREPARE for more information about …System Catalogs · System views pg_prepared_xactsCatalogs & ViewsReferencepg_prepared_xacts System views 10 The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details). …System Catalogs · System views pg_procCatalogs & ViewsReferencepg_proc System catalogs 10 The catalog pg_proc stores information about functions (or procedures). See CREATE FUNCTION and Section 37.3 for more information. The table contains data for agg…System Catalogs · System catalogs pg_propgraph_elementCatalogs & ViewsReferencepg_propgraph_element System catalogs 19 The catalog pg_propgraph_element stores information about the vertices and edges of a property graph, collectively called the elements of the property…System Catalogs · System catalogs pg_propgraph_element_labelCatalogs & ViewsReferencepg_propgraph_element_label System catalogs 19 The catalog pg_propgraph_element_label stores information about which labels apply to which elements. oid Row identifier pgellabelid Reference t…System Catalogs · System catalogs pg_propgraph_labelCatalogs & ViewsReferencepg_propgraph_label System catalogs 19 The catalog pg_propgraph_label stores information about the labels in a property graph. oid Row identifier pglpgid Reference to the property graph that …System Catalogs · System catalogs pg_propgraph_label_propertyCatalogs & ViewsReferencepg_propgraph_label_property System catalogs 19 The catalog pg_propgraph_label_property stores information about the properties in a property graph that are specific to a label. In particular…System Catalogs · System catalogs pg_propgraph_propertyCatalogs & ViewsReferencepg_propgraph_property System catalogs 19 The catalog pg_propgraph_property stores information about the properties in a property graph. This only stores information that applies to a propert…System Catalogs · System catalogs pg_publicationCatalogs & ViewsReferencepg_publication System catalogs 10 The catalog pg_publication contains all publications created in the database. For more on publications see Section 31.1. oid Row identifier (hidden attribut…System Catalogs · System catalogs pg_publication_namespaceCatalogs & ViewsReferencepg_publication_namespace System catalogs 15 The catalog pg_publication_namespace contains the mapping between schemas and publications in the database. This is a many-to-many mapping. oid Ro…System Catalogs · System catalogs pg_publication_relCatalogs & ViewsReferencepg_publication_rel System catalogs 10 The catalog pg_publication_rel contains the mapping between relations and publications in the database. This is a many-to-many mapping. See also Section…System Catalogs · System catalogs pg_publication_sequencesCatalogs & ViewsReferencepg_publication_sequences System views 19 The view pg_publication_sequences provides information about the mapping between publications and sequences. pubname Name of publication schemaname N…System Catalogs · System views pg_publication_tablesCatalogs & ViewsReferencepg_publication_tables System views 10 The view pg_publication_tables provides information about the mapping between publications and the tables they contain. Unlike the underlying catalog pg…System Catalogs · System views pg_rangeCatalogs & ViewsReferencepg_range System catalogs 10 The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type. rngtypid OID of the range type rngsubtype OID of …System Catalogs · System catalogs pg_replication_originCatalogs & ViewsReferencepg_replication_origin System catalogs 10 The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 49. roident A unique, cluster…System Catalogs · System catalogs pg_replication_origin_statusCatalogs & ViewsReferencepg_replication_origin_status System views 10 The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication orig…System Catalogs · System views pg_replication_slotsCatalogs & ViewsReferencepg_replication_slots System views 10 The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state. …System Catalogs · System views pg_rewriteCatalogs & ViewsReferencepg_rewrite System catalogs 10 The catalog pg_rewrite stores rewrite rules for tables and views. oid Row identifier (hidden attribute; must be explicitly selected) rulename Rule name ev_class…System Catalogs · System catalogs pg_rolesCatalogs & ViewsReferencepg_roles System views 10 The view pg_roles provides access to information about database roles. This is simply a publicly readable view of pg_authid that blanks out the password field. This…System Catalogs · System views pg_rulesCatalogs & ViewsReferencepg_rules System views 10 The view pg_rules provides access to useful information about query rewrite rules. schemaname Name of schema containing table tablename Name of table the rule is for…System Catalogs · System views pg_seclabelCatalogs & ViewsReferencepg_seclabel System catalogs 10 The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to vi…System Catalogs · System catalogs pg_seclabelsCatalogs & ViewsReferencepg_seclabels System views 10 The view pg_seclabels provides information about security labels. It as an easier-to-query version of the pg_seclabel catalog. objoid The OID of the object this …System Catalogs · System views pg_sequenceCatalogs & ViewsReferencepg_sequence System catalogs 10 The catalog pg_sequence contains information about sequences. Some of the information about sequences, such as the name and the schema, is in pg_class. seqreli…System Catalogs · System catalogs pg_sequencesCatalogs & ViewsReferencepg_sequences System views 10 The view pg_sequences provides access to useful information about each sequence in the database. schemaname Name of schema containing sequence sequencename Name …System Catalogs · System views pg_settingsCatalogs & ViewsReferencepg_settings System views 10 The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the SHOW and SET commands. It also provid…System Catalogs · System views pg_shadowCatalogs & ViewsReferencepg_shadow System views 10 The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. It shows properties of all roles that ar…System Catalogs · System views