Search PostgreSQL documentation

pg_replicaExtensionsExtensionsConsensus-driven automatic failover for PostgreSQL consensus database database-management failover high availability pgrx postgres-extension postgresql raft replication rust streaming replic…Administration · Extensions pg_restore_pointsExtensionsExtensionsCreate, catalog, list, and remove named PostgreSQL restore points. restore-point wal backup recovery pg_restore_points AdministrationAdministration · Extensions pg_retryExtensionsExtensionsRetry SQL statements on transient errors with exponential backoff pg_retry UtilitiesUtilities · Extensions pg_reversiExtensionsExtensionsReversi game implemented as a PostgreSQL extension. game reversi pg_reversi FeaturesFeatures · Extensions pg_rewriteExtensionsExtensionsTool allows read write to the table during the rewriting pg_rewrite AdministrationAdministration · Extensions pg_rippleExtensionsExtensionsProvides an RDF knowledge-graph engine with SPARQL, SHACL, Datalog reasoning, federation, and graph analytics inside PostgreSQL 18. knowledge-graph pgrx rdf sparql pg_ripple FeaturesFeatures · Extensions pg_riskExtensionsExtensionsDeterministic risk policies with auditable decisions policy risk audit pg_risk FeaturesFeatures · Extensions pg_rlimitExtensionsExtensionssetrlimit/getrlimit functions memory resource-limits security pg_rlimit AdministrationAdministration · Extensions pg_roastExtensionsExtensionsOpinionated PostgreSQL database auditor pg_roast SecuritySecurity · Extensions pg_role_fkey_trigger_functionsExtensionsExtensionsA bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs. foreign key function functions plpgsql postgres postgre…Security · Extensions pg_ros2ExtensionsExtensionsROS 2 graph snapshots and topic subscriptions in PostgreSQL ros2 robotics notifications pg_ros2 FeaturesFeatures · Extensions pg_row_hashesExtensionsExtensionsComputes deterministic row fingerprints, checksums, and XOR aggregates with SeaHash and FarmHash variants. checksums hashing pgrx pg_row_hashes Functions and aggregatesFunctions and aggregates · Extensions pg_rowalesceExtensionsExtensionsrowalesce() is like coalesce(), but for rows and other composite types. coalesce function functions jsonb plpgsql postgres postgresql postgresql-extension table pg_rowalesce Functions and ag…Functions and aggregates · Extensions pg_rrfExtensionsExtensionsReciprocal rank fusion functions for hybrid search pgrx pg_rrf AI and vectorsAI and vectors · Extensions pg_rruleExtensionsExtensionsRRULE field type for PostgreSQL pg_rrule Data typesData types · Extensions pg_running_statsExtensionsExtensionsMergeable Running Statistics (Welford/Chan) Extension for PostgreSQL aggregate c-programming chan-et-al custom-aggregate postgresql postgresql-extension running-statistics state-statistics w…Functions and aggregates · Extensions pg_rusageExtensionsExtensionsGathering of template plugins for PostgreSQL: background workers, logical replication things, etc. pg_rusage MonitoringMonitoring · Extensions pg_rvbbitExtensionsExtensionsSemantic SQL operators backed by configurable LLMs, with caching, receipts, and routing across multiple execution engines. pg_rvbbit AI and vectorsAI and vectors · Extensions pg_s2ExtensionsExtensionsAdds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class. gis pgrx s2 spatial pg_s2 GeospatialGeospatial · Extensions pg_safer_settingsExtensionsExtensionsFunctions and mechanisms for handling PostgreSQL settings more safely. domain function functions plpgsql postgres postgresql postgresql-extension semver settings type pg_safer_settings Admin…Administration · Extensions pg_safer_settings_table_dependent_extensionExtensionsExtensionsA handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. postgres postgresql postgresql-extension pg_safer_settings_table_dependent_extension Administra…Administration · Extensions pg_safer_settings_table_dependent_subextensionExtensionsExtensionsA handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. postgres postgresql postgresql-extension pg_safer_settings_table_dependent_subextension Adminis…Administration · Extensions pg_sag_ragExtensionsExtensionsPure-SQL multi-hop event/entity retrieval, query routing, and in-database RAG evaluation. rag retrieval routing evaluation pg_sag_rag AI and vectorsAI and vectors · Extensions pg_sageExtensionsExtensionsProvides a preload C DBA agent extension and a newer standalone Go monitoring and guarded-action sidecar. agentic database-administration mcp monitoring pg_sage AdministrationAdministration · Extensions pg_sakila_dbExtensionsExtensionsPostgreSQL extension for deploying a port of the Sakila example database. database postgres-extension sakila-db testing pg_sakila_db FeaturesFeatures · Extensions pg_sample_extExtensionsExtensionsA Sample PostgreSQL extension custom extension function postgresql sample pg_sample_ext Functions and aggregatesFunctions and aggregates · Extensions pg_sampletologExtensionsExtensionsSamples statements or whole transactions into PostgreSQL logs through executor and utility hooks. logging observability sampling pg_sampletolog MonitoringMonitoring · Extensions pg_satsExtensionsExtensionsPer-role query metering and optional enforcement using satoshi-denominated balances. metering bitcoin quota executor-hook pg_sats AdministrationAdministration · Extensions pg_saviorExtensionsExtensionsPostgres extension to save OOPS mistakes pg_savior AdministrationAdministration · Extensions pg_scwsExtensionsExtensionsa parser for full-text search of Chinese pg_scws Full-text searchFull-text search · Extensions pg_sealExtensionsExtensionsTamper-evident audit log for PostgreSQL 🦭 audit-log blake3 hash-chain logical-decoding pgrx postgres postgresql rust tamper-evident pg_seal SecuritySecurity · Extensions pg_searchExtensionsExtensionsFull text search for PostgreSQL using BM25 paradedb search analytics bm25 full-text search hybrid search faceted search columnar olap pgrx pg_search Full-text searchFull-text search · Extensions pg_secretExtensionsExtensionsDefines order-revealing encrypted domains, comparison operators, and a B-tree operator class. encryption order-revealing-encryption pg_secret SecuritySecurity · Extensions pg_semantic_cacheExtensionsExtensionsCaches query results and retrieves semantically similar results using pgvector embeddings and configurable eviction policies. rag semantic-cache vector-search pg_semantic_cache AI and vector…AI and vectors · Extensions pg_semantiusExtensionsExtensionsDatabase-first application backend with RBAC, RLS, data dictionary, and message queue. rbac rls backend queue pg_semantius FeaturesFeatures · Extensions pg_semverExtensionsExtensionsVersion(SEMVER) data type for postgresql postgresql postgresql-data-type postgresql-extension pg_semver Data typesData types · Extensions pg_sendmailExtensionsExtensionsSends email from SQL by invoking a sendmail-compatible executable at a fixed server path. email sendmail pg_sendmail UtilitiesUtilities · Extensions pg_sentence_transformerExtensionsExtensionsRuns a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table. background-worker embeddings sentence-transformers…AI and vectors · Extensions pg_sequenceExtensionsExtensionsERP document numbering with formatted, scoped, auto-incrementing sequences pg_sequence Functions and aggregatesFunctions and aggregates · Extensions pg_session_jwtExtensionsExtensionsManage authentication sessions using JWTs pgrx pg_session_jwt SecuritySecurity · Extensions