Search PostgreSQL documentation

rtosmExtensionsExtensionsReal-time simplification of spatial objects in an OpenStreetMap API database. openstreetmap spatial-simplification rtosm GeospatialGeospatial · Extensions ruidExtensionsExtensionsCompact 22-character Base64 representation of PostgreSQL UUID values. compact-identifier uuid pg_ruid Data typesData types · Extensions rule_engine_postgre_extensionsExtensionsExtensionsRust/pgrx rule-engine extension supporting GRL rules, RETE and forward/backward chaining, versioned rule repositories, triggers, and optional external integrations. business-rules grl nats p…Features · Extensions rumExtensionsExtensionsRUM index access method rum FeaturesFeatures · Extensions ruvectorExtensionsExtensionsSIMD-accelerated vector type and indexes with graph, solver, TDA, local embedding, and AI SQL functions. ai embeddings gnn graph hnsw pgrx similarity vector ruvector-postgres AI and vectorsAI and vectors · Extensions s2ExtensionsExtensionsPL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy cell-id gis python s2 s2sphere s2-postgis GeospatialGeospatial · Extensions s3_fdwExtensionsExtensionsForeign data wrapper for reading Amazon S3 files through PostgreSQL COPY format. amazon-s3 copy fdw s3_fdw Foreign data wrappersForeign data wrappers · Extensions s3_ioExtensionsExtensionsBasic Amazon S3-compatible object I/O through PostgreSQL SQL functions. object-storage pgrx s3 s3_io UtilitiesUtilities · Extensions safecastExtensionsExtensionsPure-SQL helper functions that return NULL for some invalid text-to-number casts. safe-cast sql type-conversion safecast Functions and aggregatesFunctions and aggregates · Extensions safeupdateExtensionsExtensionsRequire criteria for UPDATE and DELETE safeupdate AdministrationAdministration · Extensions saioExtensionsExtensionsExperimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO join-order planner-hook query-optimizer simulated-annealing saio F…Features · Extensions salesforce_idExtensionsExtensionsCompact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs. identifier salesforce type pg_salesforce_id Data typesData types · Extensions saturated_intExtensionsExtensionsInteger data type with saturation arithmetic that clamps overflow to int4 bounds. data-type integer saturation-arithmetic pg-saturated_int Data typesData types · Extensions scanExtensionsExtensionsVisual Studio Code - Development Container - PostgreSQL devcontainer postgres postgresql vscode scan FeaturesFeatures · Extensions schedocExtensionsExtensionsCross documentation between Django and DBT projects pg_schedoc UtilitiesUtilities · Extensions scheduleExtensionsExtensionsCron-formatted schedule type and UTC timestamp-matching functions for PostgreSQL. cron data-type scheduling utc schedule Time seriesTime series · Extensions schedulerExtensionsExtensionsExtension that enables flexible scheduling and execution of SQL and shell jobs directly within your database scheduler Time seriesTime series · Extensions schedulerxExtensionsExtensionsPrototype background-worker scheduler for periodic, one-shot, and NOTIFY-triggered SQL jobs. background-worker job-scheduler notify sql-execution generic_scheduler Time seriesTime series · Extensions schedulingExtensionsExtensionspgpm demo for the Postgres Conference 2026 scheduling Time seriesTime series · Extensions schema_triggersExtensionsExtensionsArchived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers. ddl event-trigger hooks schema pg_schema_triggers FeaturesFeatures · Extensions scriptsExtensionsExtensionsPhaseZero aftermarket application schema packaged as a PostgreSQL extension. application-schema ddl jsonb phasezero phasezero_scripts FeaturesFeatures · Extensions scrubExtensionsExtensionsBackground worker that scans heaps, B-tree indexes, TOAST data, page structure, and checksums for corruption. btree checksums corruption integrity scrubbing toast scrub AdministrationAdministration · Extensions scylla_fdwExtensionsExtensionsForeign data wrapper for querying and modifying ScyllaDB tables from PostgreSQL over CQL. cql fdw scylladb ssl write scylla_fdw Foreign data wrappersForeign data wrappers · Extensions segExtensionsPG18F.39. seg — a datatype for line segments or floating point intervals This module implements a data type seg for representing line segments, or floating point intervals. seg can represent unc…seg — a datatype for line segments or floating point intervals seller_extExtensionsExtensionsSeller-service LISTEN/NOTIFY background workers for a marketplace prototype. seller_ext FeaturesFeatures · Extensions semanticsExtensionsExtensionsAquameta Semantics Extension events plpgsql postgresql rest-api semantics system-catalog version-control-system widgets semantics FeaturesFeatures · Extensions semverExtensionsExtensionsSemantic version data type pg_semver Data typesData types · Extensions semver_rsExtensionsExtensionsA semantic version data type for PostgreSQL written in Rust semver_rs Data typesData types · Extensions sepgsqlExtensionsPG18F.40. sepgsql — SELinux-, label-based mandatory access control (MAC) security module sepgsql is a loadable module that supports label-based mandatory access control (MAC) based on SELinux se…sepgsql — SELinux-, label-based mandatory access control (MAC) security module sequential_uuidsExtensionsExtensionsgenerator of sequential UUIDs sequential_uuids Functions and aggregatesFunctions and aggregates · Extensions session_hash_toolsExtensionsExtensionsFunctions to store nested hashes in PL/Perl shared hash session_hash_tools Functions and aggregatesFunctions and aggregates · Extensions session_variableExtensionsExtensionsRegistration and manipulation of session variables and constants session_variable CompatibilityCompatibility · Extensions session_variablesExtensionsExtensionsSQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings. custom-guc key-value session-state session_variables FeaturesFeatures · Extensions set_userExtensionsExtensionssimilar to SET ROLE but with added logging set_user SecuritySecurity · Extensions setrankExtensionsExtensionsTF-IDF and cover-density ranking functions for tsvector/tsquery using document-frequency statistics from a table. full-text-search idf ranking tf-idf setrank Full-text searchFull-text search · Extensions sgp4ExtensionsExtensionsC extension that propagates satellite TLEs with SGP4 and returns WGS84 position as WKT. astronomy satellite sgp4 tle wgs84 sgp4 GeospatialGeospatial · Extensions shaExtensionsExtensionsThis module provides datatypes for storing SHA-1, SHA-2 and MD5 hashes datatype hash md5 sha sha1 sha2 sha Data typesData types · Extensions shacryptExtensionsExtensionsImplements SHA256-CRYPT and SHA512-CRYPT password encryption schemes shacrypt UtilitiesUtilities · Extensions shard_managerExtensionsExtensionsSQL/PLpgSQL toolkit for schema-based sharding, shard maps, template-table cloning, and 64-bit distributed ID generation. id-generation schema security-definer sharding shard_manager Analytic…Analytics · Extensions shardmanExtensionsExtensionsExperimental sharding, rebalance, and cross-node lock-graph prototype shardman AnalyticsAnalytics · Extensions