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 view security labels, see Section 50.74. See also pg_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster. Table 50-42. pg_seclabel Columns Name Type References Description objoid oid any OID column The OID of the object this security label pertains to classoid oid

The view pg_rules provides access to useful information about query rewrite rules. Table 50-74. pg_rules Columns Name Type References Description schemaname name pg_namespace.nspname Name of schema containing table tablename name pg_class.relname Name of table the rule is for rulename name pg_rewrite.rulename Name of rule definition text Rule definition (a reconstructed creation command) The pg_rules view excludes the ON SELECT rules of views and materialized views; those can be seen in pg

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 view explicitly exposes the OID column of the underlying table, since that is needed to do joins to other catalogs. Table 50-73. pg_roles Columns Name Type References Description rolname name Role name rolsuper bool Role has superuser privileges rolinherit bool Role automatically inherits privileges of roles it is a member o

The catalog pg_rewrite stores rewrite rules for tables and views. Table 50-41. pg_rewrite Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly selected) rulename name Rule name ev_class oid pg_class.oid The table this rule is for ev_type char Event type that the rule is for: 1 = SELECT, 2 = UPDATE, 3 = INSERT, 4 = DELETE ev_enabled char Controls in which session_replication_role modes the rule fires. O = rule fires in "origin" and "lo

The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state. For more on replication slots, see Section 26.2.6 and Chapter 47. Table 50-72. pg_replication_slots Columns Name Type References Description slot_name name A unique, cluster-wide identifier for the replication slot plugin name The base name of the shared object containing the output plugin this logical slot is using, or null for physical s

The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication origins see Chapter 48. Table 50-71. pg_replication_origin_status Columns Name Type References Description local_id Oid pg_replication_origin.roident internal node identifier external_id text pg_replication_origin.roname external node identifier remote_lsn pg_lsn The origin node's LSN up to which data has been replicated. local_lsn pg_lsn This node's

The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48. Table 50-40. pg_replication_origin Columns Name Type References Description roident Oid A unique, cluster-wide identifier for the replication origin. Should never leave the system. roname text The external, user defined, name of a replication origin. Prev Next pg_range Up pg_rewrite

The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type. Table 50-39. pg_range Columns Name Type References Description rngtypid oid pg_type.oid OID of the range type rngsubtype oid pg_type.oid OID of the element type (subtype) of this range type rngcollation oid pg_collation.oid OID of the collation used for range comparisons, or 0 if none rngsubopc oid pg_opclass.oid OID of the subtype's operator class used for range comparisons rngcan

The catalog pg_proc stores information about functions (or procedures). See CREATE FUNCTION and Section 36.3 for more information. The table contains data for aggregate functions as well as plain functions. If proisagg is true, there should be a matching row in pg_aggregate. Table 50-38. pg_proc Columns Name Type References Description oid oid Row identifier (hidden attribute; must be explicitly selected) proname name Name of the function pronamespace oid pg_namespace.oid The OID of the n

The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details). pg_prepared_xacts contains one row per prepared transaction. An entry is removed when the transaction is committed or rolled back. Table 50-70. pg_prepared_xacts Columns Name Type References Description transaction xid Numeric transaction identifier of the prepared transaction gid text Global transaction identifier that was assigned to