System Catalogs / Version comparison
What changed?
System Catalogs · PostgreSQL 18 → 19 beta 4
Pre-release documentation. These definitions may change before the final release.
6 added · 0 removed · 34 changed · 26 reworded · 0 with columns not listed. These are changes between the pinned reference snapshots. “Changed” means columns, their types, their order or a measured attribute such as NOT NULL; “reworded” means only the manual's descriptions.
rewordedpg_aggregate
--- 18 +++ 19 beta 4 @@ -16,7 +16,7 @@ aggmfinalmodify: Like aggfinalmodify, but for the aggmfinalfn aggsortop: Associated sort operator (zero if none) aggtranstype: Data type of the aggregate function's internal transition (state) data -aggtransspace: Approximate average size (in bytes) of the transition state data, or zero to use a default estimate +aggtransspace: Approximate average size (in bytes) of the transition state data. A positive value provides an estimate; zero means to use a default estimate. A negative value indicates the state data can grow unboundedly in size, such as when the aggregate accumulates input rows (e.g., array_agg, string_agg). aggmtranstype: Data type of the aggregate function's internal transition (state) data for moving-aggregate mode (zero if none) aggmtransspace: Approximate average size (in bytes) of the transition state data for moving-aggregate mode, or zero to use a default estimate agginitval: The initial value of the transition state. This is a text field containing the initial value in its external string representation. If this field is null, the transition state value starts out null.
rewordedpg_authid
--- 18 +++ 19 beta 4 @@ -7,7 +7,7 @@ rolcreatedb: Role can create databases rolcanlogin: Role can log in. That is, this role can be given as the initial session authorization identifier. rolreplication: Role is a replication role. A replication role can initiate replication connections and create and drop replication slots. -rolbypassrls: Role bypasses every row-level security policy, see Section 5.9 for more information. +rolbypassrls: Role bypasses every row-level security policy, see Section 5.10 for more information. rolconnlimit: For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit. rolpassword: Encrypted password; null if none. The format depends on the form of encryption used. rolvaliduntil: Password expiry time (only used for password authentication); null if no expiration
changedpg_available_extension_versions
18 → 19 beta 4 + location text
changedpg_available_extensions
18 → 19 beta 4 + location text
rewordedpg_class
--- 18 +++ 19 beta 4 @@ -2,7 +2,7 @@ oid: Row identifier relname: Name of the table, index, view, etc. relnamespace: The OID of the namespace that contains this relation -reltype: The OID of the data type that corresponds to this table's row type, if any; zero for indexes, sequences, and toast tables, which have no pg_type entry +reltype: The OID of the data type that corresponds to this table's row type, if any; zero for indexes, sequences, and TOAST tables, which have no pg_type entry reloftype: For typed tables, the OID of the underlying composite type; zero for all other relations relowner: Owner of the relation relam: The access method used to access this table or index. Not meaningful if the relation is a sequence or has no on-disk file, except for partitioned tables, where, if set, it takes precedence over default_table_access_method when determining the access method to use for partitions created when one is not specified in the creation command. @@ -30,6 +30,6 @@ relrewrite: For new relations being written during a DDL operation that requires a table rewrite, this contains the OID of the original relation; otherwise zero. That state is only visible internally; this field should never contain anything other than zero for a user-visible relation. relfrozenxid: All transaction IDs before this one have been replaced with a permanent (“frozen”) transaction ID in this table. This is used to track whether the table needs to be vacuumed in order to prevent transaction ID wraparound or to allow pg_xact to be shrunk. Zero (InvalidTransactionId) if the relation is not a table. relminmxid: All multixact IDs before this one have been replaced by a transaction ID in this table. This is used to track whether the table needs to be vacuumed in order to prevent multixact ID wraparound or to allow pg_multixact to be shrunk. Zero (InvalidMultiXactId) if the relation is not a table. -relacl: Access privileges; see Section 5.8 for details +relacl: Access privileges; see Section 5.9 for details reloptions: Access-method-specific options, as “keyword=value” strings relpartbound: If table is a partition (see relispartition), internal representation of the partition bound
rewordedpg_database
--- 18 +++ 19 beta 4 @@ -16,4 +16,4 @@ datlocale: Collation provider locale name for this database. If the provider is libc, datlocale is NULL; datcollate and datctype are used instead. daticurules: ICU collation rules for this database datcollversion: Provider-specific version of the collation. This is recorded when the database is created and then checked when it is used, to detect changes in the collation definition that could lead to data corruption. -datacl: Access privileges; see Section 5.8 for details +datacl: Access privileges; see Section 5.9 for details
addedpg_dsm_registry_allocations
--- 18 +++ 19 beta 4 @@ -0,0 +1,3 @@ +name text +type text +size bigint
changedpg_foreign_data_wrapper
18 → 19 beta 4 + fdwconnection oid
rewordedpg_foreign_server
--- 18 +++ 19 beta 4 @@ -5,5 +5,5 @@ srvfdw: OID of the foreign-data wrapper of this foreign server srvtype: Type of the server (optional) srvversion: Version of the server (optional) -srvacl: Access privileges; see Section 5.8 for details +srvacl: Access privileges; see Section 5.9 for details srvoptions: Foreign server specific options, as “keyword=value” strings
rewordedpg_init_privs
--- 18 +++ 19 beta 4 @@ -3,4 +3,4 @@ classoid: The OID of the system catalog the object is in objsubid: For a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero. privtype: A code defining the type of initial privilege of this object; see text -initprivs: The initial access privileges; see Section 5.8 for details +initprivs: The initial access privileges; see Section 5.9 for details
rewordedpg_language
--- 18 +++ 19 beta 4 @@ -7,4 +7,4 @@ lanplcallfoid: For noninternal languages this references the language handler, which is a special function that is responsible for executing all functions that are written in the particular language. Zero for internal languages. laninline: This references a function that is responsible for executing “inline” anonymous code blocks (DO blocks). Zero if inline blocks are not supported. lanvalidator: This references a language validator function that is responsible for checking the syntax and validity of new functions when they are created. Zero if no validator is provided. -lanacl: Access privileges; see Section 5.8 for details +lanacl: Access privileges; see Section 5.9 for details
rewordedpg_largeobject_metadata
--- 18 +++ 19 beta 4 @@ -1,4 +1,4 @@ (relation) The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in pg_largeobject. oid: Row identifier lomowner: Owner of the large object -lomacl: Access privileges; see Section 5.8 for details +lomacl: Access privileges; see Section 5.9 for details
rewordedpg_namespace
--- 18 +++ 19 beta 4 @@ -2,4 +2,4 @@ oid: Row identifier nspname: Name of the namespace nspowner: Owner of the namespace -nspacl: Access privileges; see Section 5.8 for details +nspacl: Access privileges; see Section 5.9 for details
rewordedpg_parameter_acl
--- 18 +++ 19 beta 4 @@ -1,4 +1,4 @@ (relation) 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 that have default privileges. Unlike most system catalogs, pg_parameter_acl is shared across all databases of a cluster: there is only one copy of pg_parameter_acl per cluster, not one per database. oid: Row identifier parname: The name of a configuration parameter for which privileges are granted -paracl: Access privileges; see Section 5.8 for details +paracl: Access privileges; see Section 5.9 for details
rewordedpg_proc
--- 18 +++ 19 beta 4 @@ -28,4 +28,4 @@ probin: Additional information about how to invoke the function. Again, the interpretation is language-specific. prosqlbody: Pre-parsed SQL function body. This is used for SQL-language functions when the body is given in SQL-standard notation rather than as a string literal. It's null in other cases. proconfig: Function's local settings for run-time configuration variables -proacl: Access privileges; see Section 5.8 for details +proacl: Access privileges; see Section 5.9 for details
changedpg_publication
18 → 19 beta 4 + puballsequences boolean
changedpg_publication_rel
18 → 19 beta 4 + prexcept boolean
addedpg_publication_sequences
--- 18 +++ 19 beta 4 @@ -0,0 +1,3 @@ +pubname name +schemaname name +sequencename name
changedpg_range
18 → 19 beta 4 + rngconstruct2 regproc + rngconstruct3 regproc + rngmltconstruct0 regproc + rngmltconstruct1 regproc + rngmltconstruct2 regproc
changedpg_replication_slots
18 → 19 beta 4 + slotsync_skip_reason text
rewordedpg_roles
--- 18 +++ 19 beta 4 @@ -9,6 +9,6 @@ rolconnlimit: For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit. rolpassword: Not the password (always reads as ********) rolvaliduntil: Password expiry time (only used for password authentication); null if no expiration -rolbypassrls: Role bypasses every row-level security policy, see Section 5.9 for more information. +rolbypassrls: Role bypasses every row-level security policy, see Section 5.10 for more information. rolconfig: Role-specific defaults for run-time configuration variables oid: ID of role
rewordedpg_seclabel
--- 18 +++ 19 beta 4 @@ -1,4 +1,4 @@ -(relation) 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 53.23. See also pg_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster. +(relation) 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 53.25. See also pg_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster. objoid: The OID of the object this security label pertains to classoid: The OID of the system catalog this object appears in objsubid: For a security label on a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero.
rewordedpg_shadow
--- 18 +++ 19 beta 4 @@ -4,7 +4,7 @@ usecreatedb: User can create databases usesuper: User is a superuser userepl: User can initiate streaming replication and put the system in and out of backup mode. -usebypassrls: User bypasses every row-level security policy, see Section 5.9 for more information. +usebypassrls: User bypasses every row-level security policy, see Section 5.10 for more information. passwd: Encrypted password; null if none. See pg_authid for details of how encrypted passwords are stored. valuntil: Password expiry time (only used for password authentication) useconfig: Session defaults for run-time configuration variables
rewordedpg_shseclabel
--- 18 +++ 19 beta 4 @@ -1,4 +1,4 @@ -(relation) The catalog pg_shseclabel stores security labels on shared database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, see Section 53.23. See also pg_seclabel, which performs a similar function for security labels involving objects within a single database. Unlike most system catalogs, pg_shseclabel is shared across all databases of a cluster: there is only one copy of pg_shseclabel per cluster, not one per database. +(relation) The catalog pg_shseclabel stores security labels on shared database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, see Section 53.25. See also pg_seclabel, which performs a similar function for security labels involving objects within a single database. Unlike most system catalogs, pg_shseclabel is shared across all databases of a cluster: there is only one copy of pg_shseclabel per cluster, not one per database. objoid: The OID of the object this security label pertains to classoid: The OID of the system catalog this object appears in provider: The label provider associated with this label.
changedpg_stat_all_indexes
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_stat_all_tables
18 → 19 beta 4 + stats_reset timestamp with time zone
addedpg_stat_autovacuum_scores
--- 18 +++ 19 beta 4 @@ -0,0 +1,12 @@ +relid oid +schemaname name +relname name +score double precision +xid_score double precision +mxid_score double precision +vacuum_score double precision +vacuum_insert_score double precision +analyze_score double precision +do_vacuum boolean +do_analyze boolean +for_wraparound boolean
changedpg_stat_database_conflicts
18 → 19 beta 4 + stats_reset timestamp with time zone
rewordedpg_stat_io
--- 18 +++ 19 beta 4 @@ -4,7 +4,7 @@ context: The context of an I/O operation. Possible values are: normal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. init: I/O operations performed while creating the WAL segments are tracked in context init. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table I/O operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY. reads: Number of read operations. read_bytes: The total size of read operations in bytes. -read_time: Time spent waiting for read operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero) +read_time: Time spent waiting for read operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero). This may include time spent waiting for a read started by another backend. In that case reads may still be zero. writes: Number of write operations. write_bytes: The total size of write operations in bytes. write_time: Time spent waiting for write operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
addedpg_stat_lock
--- 18 +++ 19 beta 4 @@ -0,0 +1,5 @@ +locktype text +waits bigint +wait_time double precision +fastpath_exceeded bigint +stats_reset timestamp with time zone
changedpg_stat_progress_analyze
18 → 19 beta 4 + started_by text
changedpg_stat_progress_basebackup
18 → 19 beta 4 + backup_type text
rewordedpg_stat_progress_cluster
--- 18 +++ 19 beta 4 @@ -1,11 +1,11 @@ -(relation) Whenever CLUSTER or VACUUM FULL is running, the pg_stat_progress_cluster view will contain a row for each backend that is currently running either command. The tables below describe the information that will be reported and provide information about how to interpret it. +(relation) Whenever REPACK, CLUSTER or VACUUM FULL is running, the backwards-compatibility pg_stat_progress_cluster view will contain a row for each backend that is currently running one of these commands. The tables below describe the information that will be reported and provide information about how to interpret it. pid: Process ID of backend. datid: OID of the database to which this backend is connected. datname: Name of the database to which this backend is connected. relid: OID of the table being clustered. -command: The command that is running. Either CLUSTER or VACUUM FULL. -phase: Current processing phase. See Table 27.41. -cluster_index_relid: If the table is being scanned using an index, this is the OID of the index being used; otherwise, it is zero. +command: The command that is running. Either CLUSTER or VACUUM FULL. Because this view exists for backwards-compatibility purposes only, it will translate a REPACK command into CLUSTER if index ordering is requested, or VACUUM FULL otherwise. +phase: Current processing phase. See Table 27.44. +cluster_index_relid: OID of the index defining the order of the rewritten table, or zero if no index ordering is requested. heap_tuples_scanned: Number of heap tuples scanned. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap. heap_tuples_written: Number of heap tuples written. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap. heap_blks_total: Total number of heap blocks in the table. This number is reported as of the beginning of seq scanning heap.
rewordedpg_stat_progress_copy
--- 18 +++ 19 beta 4 @@ -9,4 +9,4 @@ bytes_total: Size of source file for COPY FROM command in bytes. It is set to 0 if not available. tuples_processed: Number of tuples already processed by COPY command. tuples_excluded: Number of tuples not processed because they were excluded by the WHERE clause of the COPY command. -tuples_skipped: Number of tuples skipped because they contain malformed data. This counter only advances when a value other than stop is specified to the ON_ERROR option. +tuples_skipped: Number of tuples skipped because they contain malformed data. This counter only advances when ignore is specified to the ON_ERROR option.
rewordedpg_stat_progress_create_index
--- 18 +++ 19 beta 4 @@ -5,7 +5,7 @@ relid: OID of the table on which the index is being created. index_relid: OID of the index being created or reindexed. During a non-concurrent CREATE INDEX, this is 0. command: Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY. -phase: Current processing phase of index creation. See Table 27.44. +phase: Current processing phase of index creation. See Table 27.47. lockers_total: Total number of lockers to wait for, when applicable. lockers_done: Number of lockers already waited for. current_locker_pid: Process ID of the locker currently being waited for.
addedpg_stat_progress_repack
--- 18 +++ 19 beta 4 @@ -0,0 +1,14 @@ +pid integer +datid oid +datname name +relid oid +command text +phase text +repack_index_relid oid +heap_tuples_scanned bigint +heap_tuples_inserted bigint +heap_tuples_updated bigint +heap_tuples_deleted bigint +heap_blks_total bigint +heap_blks_scanned bigint +index_rebuild_count bigint
changedpg_stat_progress_vacuum
18 → 19 beta 4 + mode text + started_by text
addedpg_stat_recovery
--- 18 +++ 19 beta 4 @@ -0,0 +1,9 @@ +promote_triggered boolean +last_replayed_read_lsn pg_lsn +last_replayed_end_lsn pg_lsn +last_replayed_tli integer +replay_end_lsn pg_lsn +replay_end_tli integer +recovery_last_xact_time timestamp with time zone +current_chunk_start_time timestamp with time zone +pause_state text
rewordedpg_stat_replication
--- 18 +++ 19 beta 4 @@ -7,7 +7,7 @@ client_hostname: Host name of the connected client, as reported by a reverse DNS lookup of client_addr. This field will only be non-null for IP connections, and only when log_hostname is enabled. client_port: TCP port number that the client is using for communication with this WAL sender, or -1 if a Unix socket is used backend_start: Time when this process was started, i.e., when the client connected to this WAL sender -backend_xmin: This standby's xmin horizon reported by hot_standby_feedback. +backend_xmin: This standby's xmin horizon reported by hot_standby_feedback. This field will be null if a replication slot is used (in this case, the standby's xmin is shown in pg_replication_slots) or if hot_standby_feedback is disabled. state: Current WAL sender state. Possible values are: startup: This WAL sender is starting up. catchup: This WAL sender's connected standby is catching up with the primary. streaming: This WAL sender is streaming changes after its connected standby server has caught up with the primary. backup: This WAL sender is sending a backup. stopping: This WAL sender is stopping. sent_lsn: Last write-ahead log location sent on this connection write_lsn: Last write-ahead log location written to disk by this standby server
changedpg_stat_replication_slots
18 → 19 beta 4 + mem_exceeded_count bigint + slotsync_skip_count bigint + slotsync_last_skip timestamp with time zone
rewordedpg_stat_subscription
--- 18 +++ 19 beta 4 @@ -1,12 +1,12 @@ (relation) At least one row per subscription, showing information about the subscription workers. See pg_stat_subscription for details. subid: OID of the subscription subname: Name of the subscription -worker_type: Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization. +worker_type: Type of the subscription worker process. Possible types are apply, parallel apply, table synchronization, and sequence synchronization. pid: Process ID of the subscription worker process -leader_pid: Process ID of the leader apply worker if this process is a parallel apply worker; NULL if this process is a leader apply worker or a table synchronization worker -relid: OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers -received_lsn: Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers -last_msg_send_time: Send time of last message received from origin WAL sender; NULL for parallel apply workers -last_msg_receipt_time: Receipt time of last message received from origin WAL sender; NULL for parallel apply workers -latest_end_lsn: Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers -latest_end_time: Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers +leader_pid: Process ID of the leader apply worker if this process is a parallel apply worker; NULL if this process is a leader apply worker, a table synchronization worker or a sequence synchronization worker +relid: OID of the relation that the worker is synchronizing; NULL for the leader apply worker, parallel apply workers and the sequence synchronization worker +received_lsn: Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers and the sequence synchronization worker +last_msg_send_time: Send time of last message received from origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker +last_msg_receipt_time: Receipt time of last message received from origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker +latest_end_lsn: Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker +latest_end_time: Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker
changedpg_stat_subscription_stats
18 → 19 beta 4 + sync_seq_error_count bigint + sync_table_error_count bigint + confl_update_deleted bigint - sync_error_count bigint
changedpg_stat_sys_indexes
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_stat_sys_tables
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_stat_user_functions
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_stat_user_indexes
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_stat_user_tables
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_stat_wal
18 → 19 beta 4 + wal_fpi_bytes numeric
rewordedpg_stat_wal_receiver
--- 18 +++ 19 beta 4 @@ -1,6 +1,6 @@ (relation) The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server. pid: Process ID of the WAL receiver process -status: Activity status of the WAL receiver process +status: Activity status of the WAL receiver process. Possible values are: restarting: WAL receiver has been asked to restart streaming. starting: WAL receiver process has been launched but is not yet initialized. connecting: WAL receiver is connecting to the upstream server, replication has not yet started. stopping: WAL receiver has been requested to stop. streaming: WAL receiver is streaming WAL data. waiting: WAL receiver has stopped streaming and is waiting for new instructions from the startup process. receive_start_lsn: First write-ahead log location used when WAL receiver is started receive_start_tli: First timeline number used when WAL receiver is started written_lsn: Last write-ahead log location already received and written to disk, but not flushed. This should not be used for data integrity checks.
changedpg_statio_all_indexes
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_statio_all_sequences
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_statio_all_tables
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_statio_sys_indexes
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_statio_sys_sequences
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_statio_sys_tables
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_statio_user_indexes
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_statio_user_sequences
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_statio_user_tables
18 → 19 beta 4 + stats_reset timestamp with time zone
changedpg_stats
18 → 19 beta 4 + tableid oid + attnum smallint
changedpg_stats_ext
18 → 19 beta 4 + tableid oid + statistics_id oid
changedpg_stats_ext_exprs
18 → 19 beta 4 + tableid oid + statistics_id oid + range_length_histogram anyarray + range_empty_frac real + range_bounds_histogram anyarray
changedpg_subscription
18 → 19 beta 4 + subretaindeadtuples boolean + submaxretention integer + subretentionactive boolean + subserver oid + subwalrcvtimeout text ~ subconninfo NOT NULL → nullable
rewordedpg_subscription_rel
--- 18 +++ 19 beta 4 @@ -1,5 +1,5 @@ -(relation) The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping. This catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION or ALTER SUBSCRIPTION ... REFRESH PUBLICATION. +(relation) The catalog pg_subscription_rel stores the state of each replicated table and sequence for each subscription. This is a many-to-many mapping. This catalog contains tables and sequences known to the subscription after running: CREATE SUBSCRIPTION, ALTER SUBSCRIPTION ... REFRESH PUBLICATION, or ALTER SUBSCRIPTION ... REFRESH SEQUENCES. srsubid: Reference to subscription -srrelid: Reference to relation -srsubstate: State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication) -srsublsn: Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null +srrelid: Reference to table or sequence +srsubstate: State code for the table or sequence. State codes for tables: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication) State codes for sequences: i = initialize, r = ready +srsublsn: Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null. For sequences, this instead holds the publisher sequence's page LSN as of the last synchronization, which does not track replication progress the way it does for tables; see Section 29.7.2 for how it is used to detect out-of-sync sequences.
rewordedpg_tablespace
--- 18 +++ 19 beta 4 @@ -2,5 +2,5 @@ oid: Row identifier spcname: Tablespace name spcowner: Owner of the tablespace, usually the user who created it -spcacl: Access privileges; see Section 5.8 for details +spcacl: Access privileges; see Section 5.9 for details spcoptions: Tablespace-level options, as “keyword=value” strings
rewordedpg_type
--- 18 +++ 19 beta 4 @@ -30,4 +30,4 @@ typcollation: typcollation specifies the collation of the type. If the type does not support collations, this will be zero. A base type that supports collations will have a nonzero value here, typically DEFAULT_COLLATION_OID. A domain over a collatable type can have a collation OID different from its base type's, if one was specified for the domain. typdefaultbin: If typdefaultbin is not null, it is the nodeToString() representation of a default expression for the type. This is only used for domains. typdefault: typdefault is null if the type has no associated default value. If typdefaultbin is not null, typdefault must contain a human-readable version of the default expression represented by typdefaultbin. If typdefaultbin is null and typdefault is not, then typdefault is the external representation of the type's default value, which can be fed to the type's input converter to produce a constant. -typacl: Access privileges; see Section 5.8 for details +typacl: Access privileges; see Section 5.9 for details
rewordedpg_user
--- 18 +++ 19 beta 4 @@ -4,7 +4,7 @@ usecreatedb: User can create databases usesuper: User is a superuser userepl: User can initiate streaming replication and put the system in and out of backup mode. -usebypassrls: User bypasses every row-level security policy, see Section 5.9 for more information. +usebypassrls: User bypasses every row-level security policy, see Section 5.10 for more information. passwd: Not the password (always reads as ********) valuntil: Password expiry time (only used for password authentication) useconfig: Session defaults for run-time configuration variables