Search PostgreSQL documentation

pg_jobmonExtensionsExtensionsExtension for logging and monitoring functions in PostgreSQL pg_jobmon SecuritySecurity · Extensions pg_jqExtensionsExtensionsToy extension exposing libjq filters for PostgreSQL json and jsonb values. pgrx rust pg_jq UtilitiesUtilities · Extensions pg_json_diffExtensionsExtensionsJSONB diff, JSON Patch, and merge-patch functions for PostgreSQL diff jsonb merge patch pg_json_diff Functions and aggregatesFunctions and aggregates · Extensions pg_json_validateExtensionsExtensionsJSON Schema validation functions for jsonb values. pg_json_validate FeaturesFeatures · Extensions pg_jsonpatchExtensionsExtensionsPostgreSQL implementation of JSON Patch jsonpatch nix postgresql postgresql-extension pg_jsonpatch Functions and aggregatesFunctions and aggregates · Extensions pg_jsonschemaExtensionsExtensionsPostgreSQL extension providing JSON Schema validation pgrx supabase pg_jsonschema FeaturesFeatures · Extensions pg_kaboomExtensionsExtensionsBlow things up in interesting and useful^W^W ways crash failover kaboom testing pg_kaboom FeaturesFeatures · Extensions pg_kafkaExtensionsExtensionsKafka foreign data wrapper for PostgreSQL. kafka pgrx postgresql rust pg_kafka Foreign data wrappersForeign data wrappers · Extensions pg_kafka_eventsExtensionsExtensionsPublishes PostgreSQL logical-decoding change events to Apache Kafka through a background worker. kafka pg_kafka_events Replication and streamsReplication and streams · Extensions pg_kalamExtensionsExtensionsKalamDB PostgreSQL extension and FDW callback layer for SQL access to KalamDB. fdw pgrx kalam-pg-extension Foreign data wrappersForeign data wrappers · Extensions pg_kalmanExtensionsExtensionsA Kalman filter extension for PostgreSQL. pg_kalman Functions and aggregatesFunctions and aggregates · Extensions pg_kazsearchExtensionsExtensionsKazakh full-text search extension for PostgreSQL pgrx pg_kazsearch Full-text searchFull-text search · Extensions pg_keeperExtensionsExtensionsBackground-worker based clustering module for monitoring streaming replication, changing synchronous replication mode and promoting a standby on failure. pg_keeper AdministrationAdministration · Extensions pg_kmersearchExtensionsExtensionsA PostgreSQL extension adding 2 datatypes of 2-bit or 4-bit per 1-mer for nucleotide sequence data and GIN index based on k-mer pg_kmersearch AI and vectorsAI and vectors · Extensions pg_knowledge_graphExtensionsExtensionsKnowledge graph extension for PostgreSQL with graph algorithms and pgvector integration. graph pgrx rag vector pg_knowledge_graph AI and vectorsAI and vectors · Extensions pg_kpartExtensionsExtensionsReject full partition scans that omit the partition key pg_kpart SecuritySecurity · Extensions pg_ladybugExtensionsExtensionsCypher queries over PostgreSQL tables through an embedded Ladybug graph engine. graph cypher ladybugdb extension-scan pg_ladybug FeaturesFeatures · Extensions pg_lakeExtensionsExtensionsData lake extension by Snowflake data-lake duckdb fdw iceberg pg_lake AnalyticsAnalytics · Extensions pg_lake_benchmarkExtensionsExtensionsProvides ClickBench, TPC-H and TPC-DS data generation and benchmark queries for pg_lake, Iceberg and heap tables. benchmark clickbench data-lake tpcds tpch pg_lake FeaturesFeatures · Extensions pg_lake_copyExtensionsExtensionsCopy to/from data lake files copy csv data-lake json parquet pg_lake AnalyticsAnalytics · Extensions pg_lake_engineExtensionsExtensionsQuery engine for data lake queries data-lake duckdb olap query-engine pg_lake AnalyticsAnalytics · Extensions pg_lake_icebergExtensionsExtensionsIceberg implementation in Postgres catalog data-lake iceberg pg_lake AnalyticsAnalytics · Extensions pg_lake_spatialExtensionsExtensionsAdds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows. geospatial postgis pg_lake GeospatialGeospatial · Extensions pg_lake_tableExtensionsExtensionsData lake tables and Iceberg tables data-lake fdw iceberg pg_lake AnalyticsAnalytics · Extensions pg_lakebase_runtimeExtensionsExtensionsShared runtime for Lakebase table access method extensions iceberg lakebase lakehouse postgresql postgresql-extension pg_lakebase_runtime AnalyticsAnalytics · Extensions pg_lakehouseExtensionsExtensionsAn analytical query engine for PostgreSQL data-lake datafusion fdw pgrx pg_lakehouse AnalyticsAnalytics · Extensions pg_landmetricsExtensionsExtensionsA PostgreSQL/PostGIS extension for calculating landscape metrics. charts geojson geospatial landscape-metrics statistics pg_landmetrics GeospatialGeospatial · Extensions pg_laterExtensionsExtensionsRun queries now and get results later pgrx pg_later Time seriesTime series · Extensions pg_learnedExtensionsExtensionsPostgreSQL extension for learned indexes - 2-10x faster queries with machine learning pg_learned FeaturesFeatures · Extensions pg_ledgerExtensionsExtensionsProvides a double-entry accounting engine with immutable journals, fiscal periods, currencies and posting rules inside PostgreSQL. pgrx pg_ledger FeaturesFeatures · Extensions pg_lexoExtensionsExtensionsProvides a Base62 lexicographic position type and helper functions for stable list ordering and reordering without bulk row updates. pgrx pg_lexo Data typesData types · Extensions pg_libnumbertextExtensionsExtensionsConverts numbers to words in multiple languages through libnumbertext. libnumbertext localization number-to-words text pg_libnumbertext Functions and aggregatesFunctions and aggregates · Extensions pg_libphonenumberExtensionsExtensionsAdds a packed phone-number type and parsing functions backed by Google libphonenumber. pg_libphonenumber Data typesData types · Extensions pg_linearAlgebraExtensionsExtensionsA linear algebra extension pgrx rust pg_linearalgebra Functions and aggregatesFunctions and aggregates · Extensions pg_linegazerExtensionsExtensionsTransparent code coverage for PL/pgSQL code-coverage plpgsql preload pg_linegazer Procedural languagesProcedural languages · Extensions pg_liquidExtensionsExtensionsLiquid-inspired Datalog graph query extension for PostgreSQL pg_liquid FeaturesFeatures · Extensions pg_living_assertionsExtensionsExtensionsExecutable SQL checks with verdict dates and assertion history assertions monitoring drift pg_living_assertions AdministrationAdministration · Extensions pg_llmExtensionsExtensionsIntegrates local and remote large-language models with chat, sessions, text-to-SQL, audit and vector-backed knowledge features. llm rag pg_llm AI and vectorsAI and vectors · Extensions pg_llm_bgwExtensionsExtensionsexample of Rust implementation of background workder to call LLM from within PostGres client DML SQL pg_llm_bgw AI and vectorsAI and vectors · Extensions pg_llm_helperExtensionsExtensionsCaptures PostgreSQL errors in shared memory and exposes history plus an optional pgai-backed LLM troubleshooting function. llm pg_llm_helper MonitoringMonitoring · Extensions