Search PostgreSQL documentation

pg_promoterExtensionsExtensionspg promoter is simplified clustering module based on bgworker. pg_promoter AdministrationAdministration · Extensions pg_prosupportExtensionsExtensionsPlanner support functions for bounded numeric aggregate rewrites planner numeric aggregation pg_prosupport FeaturesFeatures · Extensions pg_protect_columnsExtensionsExtensionsA set of postgres functions that allow you to protect columns that should not be updated. column-protection immutability trigger pg_protect_columns AdministrationAdministration · Extensions pg_protobufExtensionsExtensionsProtobuf support for PostgreSQL pg_protobuf UtilitiesUtilities · Extensions pg_prttn_toolsExtensionsExtensionsProvides PL/pgSQL tools for managing inheritance-based partition tables. partitioning pg_prttn_tools AnalyticsAnalytics · Extensions pg_pulseExtensionsExtensionsActive Session History (ASH) for PostgreSQL active-session-history background-workers database-performance postgresql-extension pg_pulse MonitoringMonitoring · Extensions pg_punycodeExtensionsExtensionsPunycode and IDNA/UTS-46 domain-name conversion functions. punycode idna domain unicode pg_punycode UtilitiesUtilities · Extensions pg_purrExtensionsExtensionsA PostgreSQL extension (via PL/Python) that brings quantum computing capabilities. pg_purr Functions and aggregatesFunctions and aggregates · Extensions pg_pwhashExtensionsExtensionsAdvanced password hashing methods for PostgreSQL pg_pwhash SecuritySecurity · Extensions pg_py_extExtensionsExtensionsA PostgreSQL extension using PL/Python3U to add numbers addition extension gsoc postgresql postgresql-extension procedural language tutorial pg_py_ext Functions and aggregatesFunctions and aggregates · Extensions pg_py_plan_forwardingExtensionsExtensionsForward PostgreSQL planner and executor data to embedded Python callbacks planner-hook python query-plan pg_py_plan_forwarding FeaturesFeatures · Extensions pg_qualstatsExtensionsExtensionsAn extension collecting statistics about quals pg_qualstats MonitoringMonitoring · Extensions pg_query_rewriteExtensionsExtensionsRewrite SQL statements with a PostgreSQL ProcessUtility hook pg_query_rewrite AdministrationAdministration · Extensions pg_query_rulesExtensionsExtensionsProxySQL Query Rules but for PostgreSQL pg_query_rules AdministrationAdministration · Extensions pg_query_settingsExtensionsExtensionsModule that dynamically set queries parameters based on their queryid pg_query_settings AdministrationAdministration · Extensions pg_query_stateExtensionsExtensionsTool for query progress monitoring in PostgreSQL monitoring progress query-plan runtime-explain pg_query_state MonitoringMonitoring · Extensions pg_query_statsExtensionsExtensionsLightweight shared-memory collector for per-query execution statistics. pg_query_stats MonitoringMonitoring · Extensions pg_queryidExtensionsExtensionsCompute configurable external query fingerprints for PostgreSQL fingerprint queryid statistics pg_queryid MonitoringMonitoring · Extensions pg_querylogExtensionsExtensionsCaptures current and recently completed backend queries in shared memory for SQL inspection. observability query-logging pg_querylog MonitoringMonitoring · Extensions pg_quotaExtensionsExtensionsEnforce soft per-role disk-space quotas with background workers background-worker disk-quota resource-control pg_quota AdministrationAdministration · Extensions pg_rand_extExtensionsExtensionsFunctions that generate random values for PostgreSQL extension pgbench postgresql random pg_rand_ext Functions and aggregatesFunctions and aggregates · Extensions pg_random_stringExtensionsExtensionsGenerates an alphanumeric string of a requested length with a C function. random-data pg_random_string Functions and aggregatesFunctions and aggregates · Extensions pg_rationalExtensionsExtensionsbigint fractions pg_rational Data typesData types · Extensions pg_reactiveExtensionsExtensionsLive SQL query subscriptions with result deltas over LISTEN/NOTIFY live-queries notifications cdc pg_reactive FeaturesFeatures · Extensions pg_readmeExtensionsExtensionsGenerate a Markdown README from PostgreSQL COMMENT objects documentation markdown meta plpgsql function functions pg_readme UtilitiesUtilities · Extensions pg_readme_test_extensionExtensionsExtensionsFixture extension used to test pg_readme document generation documentation markdown testing fixture plpgsql pg_readme UtilitiesUtilities · Extensions pg_readonlyExtensionsExtensionscluster database read only pg_readonly AdministrationAdministration · Extensions pg_recall_guardExtensionsExtensionsMeasure ANN index recall and detect drift from an approved baseline vector ann recall monitoring drift baseline pg_recall_guard AI and vectorsAI and vectors · Extensions pg_recyclebinExtensionsExtensionsIntercepts DROP TABLE and TRUNCATE to retain recoverable table data and metadata in a recycle-bin schema. flashback pgrx recovery pg_recyclebin AdministrationAdministration · Extensions pg_redispubExtensionsExtensionsPublish channel messages from PostgreSQL to a local Redis server messaging publish redis pg_redispub Replication and streamsReplication and streams · Extensions pg_registryExtensionsExtensionsStores and validates JSON Schemas, generates schemas from tables, and binds schemas to Kafka topics. json-schema pgrx schema-registry pg_registry FeaturesFeatures · Extensions pg_regresqlExtensionsExtensionsTrust pg_class statistics for planning instead of physical relation size pg_regresql Procedural languagesProcedural languages · Extensions pg_reject_truncateExtensionsExtensionsRejects or prevents TRUNCATE operations in PostgreSQL. hook security truncate pg_reject_truncate AdministrationAdministration · Extensions pg_relation_sqlExtensionsExtensionsGenerate inlinable SQL functions for navigating PostgreSQL foreign-key relations foreign-key relations sql-functions code-generation planner inlining ddl pg_relation_sql UtilitiesUtilities · Extensions pg_relayExtensionsExtensionsDurable event processor for PostgreSQL extension go golang listen-notify postgres postgresql postgresql extension relay pg_relay FeaturesFeatures · Extensions pg_relusageExtensionsExtensionsLog all the queries that reference a particular column pg_relusage MonitoringMonitoring · Extensions pg_remote_execExtensionsExtensionsExecutes shell commands from SQL and optionally returns their standard output. administration shell-execution pg_remote_exec AdministrationAdministration · Extensions pg_renderExtensionsExtensionsRender HTML in SQL pgrx pg_render UtilitiesUtilities · Extensions pg_repackExtensionsExtensionsReorganize tables in PostgreSQL databases with minimal locks pg_repack AdministrationAdministration · Extensions pg_repeaterExtensionsExtensionsReplicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw. distributed-query query-plan pg_repeater Replication and streamsReplication and streams · Extensions