Search PostgreSQL documentation

pg_kpartExtensionsExtensionsSecurity · ExtensionsReject full partition scans that omit the partition key pg_kpart Security pg_ladybugExtensionsExtensionsFeatures · ExtensionsCypher queries over PostgreSQL tables through an embedded Ladybug graph engine. graph cypher ladybugdb extension-scan pg_ladybug Features pg_lakeExtensionsExtensionsAnalytics · ExtensionsData lake extension by Snowflake data-lake duckdb fdw iceberg pg_lake Analytics pg_lake_benchmarkExtensionsExtensionsFeatures · ExtensionsProvides 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 Features pg_lake_copyExtensionsExtensionsAnalytics · ExtensionsCopy to/from data lake files copy csv data-lake json parquet pg_lake Analytics pg_lake_engineExtensionsExtensionsAnalytics · ExtensionsQuery engine for data lake queries data-lake duckdb olap query-engine pg_lake Analytics pg_lake_icebergExtensionsExtensionsAnalytics · ExtensionsIceberg implementation in Postgres catalog data-lake iceberg pg_lake Analytics pg_lake_spatialExtensionsExtensionsGeospatial · ExtensionsAdds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows. geospatial postgis pg_lake Geospatial pg_lake_tableExtensionsExtensionsAnalytics · ExtensionsData lake tables and Iceberg tables data-lake fdw iceberg pg_lake Analytics pg_lakebase_runtimeExtensionsExtensionsAnalytics · ExtensionsShared runtime for Lakebase table access method extensions iceberg lakebase lakehouse postgresql postgresql-extension pg_lakebase_runtime Analytics pg_lakehouseExtensionsExtensionsAnalytics · ExtensionsAn analytical query engine for PostgreSQL data-lake datafusion fdw pgrx pg_lakehouse Analytics pg_landmetricsExtensionsExtensionsGeospatial · ExtensionsA PostgreSQL/PostGIS extension for calculating landscape metrics. charts geojson geospatial landscape-metrics statistics pg_landmetrics Geospatial pg_languageManual ChaptersPG18The catalog pg_language registers languages in which you can write functions or stored procedures. See CREATE LANGUAGE and Chapter 40 for more information about language handlers. Table 52.2… pg_largeobjectManual ChaptersPG18The catalog pg_largeobject holds the data making up “large objects”. A large object is identified by an OID assigned when it is created. Each large object is broken into segments or “pages” … pg_largeobject_metadataManual ChaptersPG18The catalog pg_largeobject_metadata holds metadata associated with large objects. The actual large object data is stored in pg_largeobject. Table 52.31. pg_largeobject_metadata Columns Colum… pg_laterExtensionsExtensionsTime series · ExtensionsRun queries now and get results later pgrx pg_later Time series pg_learnedExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension for learned indexes - 2-10x faster queries with machine learning pg_learned Features pg_ledgerExtensionsExtensionsFeatures · ExtensionsProvides a double-entry accounting engine with immutable journals, fiscal periods, currencies and posting rules inside PostgreSQL. pgrx pg_extensions Features pg_lexoExtensionsExtensionsData types · ExtensionsProvides a Base62 lexicographic position type and helper functions for stable list ordering and reordering without bulk row updates. pgrx pg_lexo Data types pg_libnumbertextExtensionsExtensionsFunctions and aggregates · ExtensionsConverts numbers to words in multiple languages through libnumbertext. libnumbertext localization number-to-words text pg_libnumbertext Functions and aggregates pg_libphonenumberExtensionsExtensionsData types · ExtensionsAdds a packed phone-number type and parsing functions backed by Google libphonenumber. pg_libphonenumber Data types pg_linearAlgebraExtensionsExtensionsFunctions and aggregates · ExtensionsA linear algebra extension pgrx rust pg_linearalgebra Functions and aggregates pg_linegazerExtensionsExtensionsProcedural languages · ExtensionsTransparent code coverage for PL/pgSQL code-coverage plpgsql preload pg_linegazer Procedural languages pg_liquidExtensionsExtensionsFeatures · ExtensionsLiquid-inspired Datalog graph query extension for PostgreSQL pg_liquid Features pg_living_assertionsExtensionsExtensionsAdministration · ExtensionsExecutable SQL checks with verdict dates and assertion history assertions monitoring drift pg_living_assertions Administration pg_llmExtensionsExtensionsAI and vectors · ExtensionsIntegrates local and remote large-language models with chat, sessions, text-to-SQL, audit and vector-backed knowledge features. llm rag pg_llm AI and vectors pg_llm_bgwExtensionsExtensionsAI and vectors · Extensionsexample of Rust implementation of background workder to call LLM from within PostGres client DML SQL pg_llm_bgw AI and vectors pg_llm_helperExtensionsExtensionsMonitoring · ExtensionsCaptures PostgreSQL errors in shared memory and exposes history plus an optional pgai-backed LLM troubleshooting function. llm pg_llm_helper Monitoring pg_local_cacheExtensionsExtensionsFeatures · ExtensionsTransaction-aware shared-memory cache for explicit PostgreSQL primary-key mget and optional RESP2 reads cache mget resp2 performance primary-key shared-memory transactions pg_local_cache Fea… pg_lock_poolExtensionsExtensionsAdministration · ExtensionsWait on a PostgreSQL advisory lock pool advisory-lock lock-pool plpgsql pg_lock_pool Administration pg_locksManual ChaptersPG18The view pg_locks provides access to information about the locks held by active processes within the database server. See Chapter 13 for more discussion of locking. pg_locks contains one row… pg_lockwatchExtensionsExtensionsMonitoring · ExtensionsSample blocking chains and score lock-contention risk locks monitoring alerts pg_lockwatch Monitoring pg_logExtensionsExtensionsMonitoring · Extensionsdisplays log content from SQL c log messages postgresql postgresql-extension sql pg_log Monitoring pg_log_statementsExtensionsExtensionsMonitoring · ExtensionsEnables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters. logging pg_log_statements Monitoring pg_log_userqueriesExtensionsExtensionsMonitoring · ExtensionsModule to log user queries log query syslog pg_log_userqueries Monitoring pg_logfebeExtensionsExtensionsMonitoring · Extensionslog via febe framing protocol to a unix socket febe logging preload structured-logging unix-socket pg_logfebe Monitoring pg_logfmtExtensionsExtensionsUtilities · ExtensionsParse logfmt strings into JSONB and key sets jsonb logfmt parser pgrx pg_logfmt Utilities pg_loggingExtensionsExtensionsMonitoring · ExtensionsCaptures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions. logging pg_logging Monitoring pg_logical_ddlExtensionsExtensionsReplication and streams · ExtensionsExperimental DDL replication implementation for PostgreSQL pg_logical_ddl Replication and streams pg_logicalinspectExtensionsPG18pg_logicalinspect — logical decoding components inspectionlogical decoding components inspection The pg_logicalinspect module provides SQL functions that allow you to inspect the contents of logical decoding components. It allows the inspection of …