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_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_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the SHOW and SET commands. It also provides access to some facts about each parameter that are not directly available from SHOW, such as minimum and maximum values. Table 50-76. pg_settings Columns Name Type Description name text Run-time configuration parameter name setting text Current value of the parameter unit text Implicit unit of the parameter category text Logical g

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 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_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_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 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 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 pg_prepared_statements view displays all the prepared statements that are available in the current session. See PREPARE for more information about prepared statements. pg_prepared_statements contains one row for each prepared statement. Rows are added to the view when a new prepared statement is created and removed when a prepared statement is released (for example, via the DEALLOCATE command). Table 50-69. pg_prepared_statements Columns Name Type Description name text The identifier of t