Search PostgreSQL documentation

pg_config --sharedirCommand-line ToolsPG18--sharedir Print the location of architecture-independent support files.pg_config › Options pg_config --sysconfdirCommand-line ToolsPG18--sysconfdir Print the location of system-wide configuration files.pg_config › Options pg_config --versionCommand-line ToolsPG18--version Print the version of PostgreSQL.pg_config › Options pg_conn2ExtensionsExtensionsManage separate PostgreSQL database connections from SQL code pg_conn2 Foreign data wrappersForeign data wrappers · Extensions pg_connlimitExtensionsExtensionsLimits per-role connection counts from filesystem configuration without catalog access. pg_connlimit AdministrationAdministration · Extensions pg_constraintManual ChaptersPG1852.13. pg_constraint The catalog pg_constraint stores check, not-null, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated specially. E…pg_constraint 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_consulExtensionsExtensionsC++ PostgreSQL extension exposing SQL functions for Consul status, catalog, and key-value APIs. consul key-value service-discovery pg_consul UtilitiesUtilities · Extensions pg_contextdumpExtensionsExtensionsReports allocated-memory statistics for PostgreSQL memory contexts. pg_memorydump MonitoringMonitoring · Extensions pg_control_checkpointFunctionsReferencepg_control_checkpoint System Information Functions And Operators 10 Returns information about current checkpoint state. pg_control_checkpoint ( ) → record Returns information about current c…Functions · System Information Functions And Operators pg_control_initFunctionsReferencepg_control_init System Information Functions And Operators 10 Returns information about cluster initialization state. pg_control_init ( ) → record Returns information about cluster initializ…Functions · System Information Functions And Operators pg_control_priorityExtensionsExtensionsControls scheduling priorities (nice values) of PostgreSQL server processes. process-control resource-management pg_control_priority AdministrationAdministration · Extensions pg_control_recoveryFunctionsReferencepg_control_recovery System Information Functions And Operators 10 Returns information about recovery state. pg_control_recovery ( ) → record Returns information about recovery state. 11 12 1…Functions · System Information Functions And Operators pg_control_systemFunctionsReferencepg_control_system System Information Functions And Operators 10 Returns information about current control file state. pg_control_system ( ) → record Returns information about current control…Functions · System Information Functions And Operators pg_controldataCommand-line ToolsPG18pg_controldata pg_controldata — display control information of a PostgreSQL database cluster Synopsis pg_controldata [option] [[ -D | --pgdata ]datadir]pg_controldata pg_controldataManual ChaptersPG18pg_controldata pg_controldata — display control information of a PostgreSQL database cluster Synopsis pg_controldata [option] [[ -D | --pgdata ]datadir]pg_controldata pg_conversionManual ChaptersPG1852.14. pg_conversion The catalog pg_conversion describes encoding conversion functions. See CREATE CONVERSION for more information. Table 52.14. pg_conversion Columns Column Type Description…pg_conversion 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_conversion_is_visibleFunctionsReferencepg_conversion_is_visible System Information Functions And Operators 10 is conversion visible in search path pg_conversion_is_visible ( conversion_oid ) → boolean is conversion visible in sea…Functions · System Information Functions And Operators pg_cooldownExtensionsExtensionsremove buffered pages for specific relations pg_cooldown AdministrationAdministration · Extensions pg_copy_logical_replication_slotFunctionsReferencepg_copy_logical_replication_slot System Administration Functions 12 Copies an existing logical replication slot named src_slot_name to a logical replication slot named dst_slot_name while ch…Functions · System Administration Functions pg_copy_physical_replication_slotFunctionsReferencepg_copy_physical_replication_slot System Administration Functions 12 Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name. The …Functions · System Administration Functions pg_coredumpExtensionsExtensionsEasier core dump collection for PostgreSQL pg_coredump AdministrationAdministration · Extensions pg_crashExtensionsExtensionsSend random signals to random processes pg_crash AdministrationAdministration · Extensions pg_crasherExtensionsExtensionsProvides a function that intentionally crashes a PostgreSQL backend for client error-handling tests. crash error-handling testing pg_crasher FeaturesFeatures · Extensions pg_crdt_jsonbExtensionsExtensionsConflict-free replicated data type operations for PostgreSQL jsonb values. pg_crdt_jsonb Data typesData types · Extensions pg_create_logical_replication_slotFunctionsReferencepg_create_logical_replication_slot System Administration Functions 10 Creates a new logical (decoding) replication slot named slot_name using the output plugin plugin. The optional third par…Functions · System Administration Functions pg_create_physical_replication_slotFunctionsReferencepg_create_physical_replication_slot System Administration Functions 10 Creates a new physical replication slot named slot_name. The optional second parameter, when true, specifies that the L…Functions · System Administration Functions pg_create_restore_pointFunctionsReferencepg_create_restore_point System Administration Functions 10 Create a named point for performing restore (restricted to superusers by default, but other users can be granted EXECUTE to run the…Functions · System Administration Functions pg_createsubscriberCommand-line ToolsPG18pg_createsubscriber pg_createsubscriber — convert a physical replica into a new logical replica Synopsis pg_createsubscriber [option...] { -d | --database }dbname { -D | --pgdata }datadir { …pg_createsubscriber pg_createsubscriberManual ChaptersPG18pg_createsubscriber pg_createsubscriber — convert a physical replica into a new logical replica Synopsis pg_createsubscriber [option...] { -d | --database }dbname { -D | --pgdata }datadir { …pg_createsubscriber pg_createsubscriber --allCommand-line ToolsPG18-a--all Create one subscription per database on the target server. Exceptions are template databases and databases that don't allow connections. To discover the list of all databases, connec…pg_createsubscriber › Options pg_createsubscriber --clean=objtypeCommand-line ToolsPG18--clean=objtype Drop all objects of the specified type from specified databases on the target server. publications: The FOR ALL TABLES publications established for this subscriber are always…pg_createsubscriber › Options pg_createsubscriber --config-file=filenameCommand-line ToolsPG18--config-file=filename Use the specified main server configuration file for the target data directory. pg_createsubscriber internally uses the pg_ctl command to start and stop the target ser…pg_createsubscriber › Options pg_createsubscriber --database=dbnameCommand-line ToolsPG18-d dbname--database=dbname The name of the database in which to create a subscription. Multiple databases can be selected by writing multiple -d switches. This option cannot be used together…pg_createsubscriber › Options pg_createsubscriber --dry-runCommand-line ToolsPG18-n--dry-run Do everything except actually modifying the target directory.pg_createsubscriber › Options pg_createsubscriber --enable-two-phaseCommand-line ToolsPG18-T--enable-two-phase Enables two_phase commit for the subscription. When multiple databases are specified, this option applies uniformly to all subscriptions created on those databases. The …pg_createsubscriber › Options pg_createsubscriber --helpCommand-line ToolsPG18-?--help Show help about pg_createsubscriber command line arguments, and exit.pg_createsubscriber › Options pg_createsubscriber --pgdata=directoryCommand-line ToolsPG18-D directory--pgdata=directory The target directory that contains a cluster directory from a physical replica.pg_createsubscriber › Options pg_createsubscriber --publication=nameCommand-line ToolsPG18--publication=name The publication name to set up the logical replication. Multiple publications can be specified by writing multiple --publication switches. The number of publication names …pg_createsubscriber › Options