Search PostgreSQL documentation

kafkaExtensionsExtensionsReplication and streams · ExtensionsProduce messages to Apache Kafka from PostgreSQL kafka messaging preload pg_kafka Replication and streams kafka_fdwExtensionsExtensionsForeign data wrappers · Extensionskafka Foreign Data Wrapper for CSV formatted messages kafka_fdw Foreign data wrappers Kernel Resource UsageManual ChaptersPG18Resource Consumptionmax_files_per_process (integer) # Sets the maximum number of open files each server subprocess is allowed to open simultaneously; files already opened in the postmaster are not counted towar… key_column_usageManual ChaptersPG18The view key_column_usage identifies all columns in the current database that are restricted by some unique, primary key, or foreign key constraint. Check constraints are not included in thi… keyhippoExtensionsExtensionsSecurity · ExtensionsRLS-compatible API keys for PostgreSQL auth rls roles supabase tle keyhippo Security Keyword/Value Connection StringsManual ChaptersPG18Database Connection Control FunctionsIn the keyword/value format, each parameter setting is in the form keyword = value, with space(s) between settings. Spaces around a setting's equal sign are optional. To write an empty value… kham_pgExtensionsExtensionsFull-text search · ExtensionsThai word-segmentation FTS parser — tsvector, soundex, RTGS romanization, NER fts named-entity nlp parser romanization soundex thai tokenizer kham_pg Full-text search khulnasoft_vaultExtensionsExtensionsSecurity · ExtensionsKhulnasoft Vault Extension khulnasoft_vault Security kilobaseExtensionsExtensionsTime series · ExtensionsPreloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views. background-worker materialized-view pgrx scheduling kilobase Time series kissfftExtensionsExtensionsFunctions and aggregates · ExtensionsFast-Fourier transformer (fft) aggregate fft fourier pgfft Functions and aggregates kite_fdwExtensionsExtensionsForeign data wrappers · ExtensionsForeign data wrapper for remote Kite servers postgres-kite Foreign data wrappers kiwicopple-is_evenExtensionsExtensionsFunctions and aggregates · ExtensionsCalculates if a value is even. database.dev tle kiwicopple-is_even Functions and aggregates kmeaExtensionsExtensionsData types · ExtensionsK-Mer Extension for Analysis kmea Data types kmeansExtensionsExtensionsAI and vectors · ExtensionsK-means clustering window function for PostgreSQL analysis clustering k-means statistics window-function kmeans AI and vectors kmoneyExtensionsExtensionsData types · ExtensionsExact scale-18 monetary types with one SQL type per currency. money currency fixed-point iso-4217 kamu-money-pg Data types knxExtensionsExtensionsData types · Extensionsdata types for KNX Addresses address datatype knx pgknx Data types koldstoreExtensionsExtensionsAnalytics · ExtensionsPostgreSQL tiered-storage that moves historical rows to Parquet while keeping the original table fully queryable and supporting updates and deletes. cold-storage database datalake multi-tena… konfigrafExtensionsExtensionsFeatures · ExtensionsGit based application configuration config configuration git konfigraf Features kor_searchExtensionsExtensionsFull-text search · ExtensionsA PostgreSQL extension for Korean-English text search. english fts korean similarity synonyms kor_search Full-text search kq_cxExtensionsExtensionsTime series · ExtensionsPreloaded in-memory calendar cache and date-arithmetic functions for ketteQ PostgreSQL schemas. cache calendar pgrx preload kq_cx Time series kq_fxExtensionsExtensionsFunctions and aggregates · ExtensionsketteQ, Inc. currency fx pgrx kq_fx Functions and aggregates ksjExtensionsExtensionsData types · ExtensionsJapanese kanji-numeral integer type with arithmetic, aggregates, casts, comparison, and B-tree indexing integer japanese kanji numeric ksj Data types kt_fdwExtensionsExtensionsForeign data wrappers · ExtensionsForeign data wrapper for reading and writing Kyoto Tycoon key-value stores. fdw kyoto-tycoon kt_fdw Foreign data wrappers kv_fdwExtensionsExtensionsForeign data wrappers · ExtensionsForeign data wrapper for key-value storage backed by RocksDB/VidarDB. fdw key-value rocksdb kv_fdw Foreign data wrappers l10n_table_dependent_extensionExtensionsExtensionsData types · ExtensionsPostgreSQL l10n toolbox pg_xenophile Data types lab-ordersExtensionsExtensionsFeatures · Extensionspgpm demo for the Postgres Conference 2026 lab-orders Features lambdaExtensionsExtensionsProcedural languages · Extensionsfunction for Postgres function functions lambda plpgsql pg_lambda Procedural languages lanceExtensionsExtensionsForeign data wrappers · ExtensionsPostgreSQL FDW extension for reading and querying Lance format tables arrow fdw lance pgrx lance Foreign data wrappers languageExtensionsExtensionsData types · ExtensionsCustom PostgreSQL language enumeration type enum language type pg_language Data types Language TagManual ChaptersPG18Locale SupportA language tag, defined in BCP 47, is a standardized identifier used to identify languages, regions, and other information about a locale. Basic language tags are simply language-region; or … lantern_extrasExtensionsExtensionsAI and vectors · ExtensionsConvenience functions for working with vector embeddings ai embeddings llm pgrx vector lantern_extras AI and vectors Large ObjectsManual ChaptersPG18are not directly supported by ECPG, but ECPG application can manipulate large objects through the libpq large object functions, obtaining the necessary PGconn object by calling the ECPGget_P… Large ObjectsManual ChaptersPG18PostgreSQL has a large object facility, which provides stream-style access to user data that is stored in a special large-object structure. Streaming access is useful when working with data … LATERALSQL CommandsPG18Table Expressions › The FROM Clause › LATERAL SubqueriesSubqueries # Subqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns provided by preceding FROM items. (Without LATERAL, each subquery is … LATERAL SubqueriesManual ChaptersPG18Table ExpressionsSubqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns provided by preceding FROM items. (Without LATERAL, each subquery is evaluated ind… latitudeFunctionsPG18earthdistance — calculate great-circle distances › Cube-Based Earth Distances( earth ) → float8 Returns the latitude in degrees of a point on the surface of the Earth. launchql-base32ExtensionsExtensionsSecurity · ExtensionsRFC6238 TOTP implementation in pure PostgreSQL plpgsql launchql-base32 Security launchql-ext-default-rolesExtensionsExtensionsSecurity · ExtensionsCreate the anonymous, authenticated and administrator roles used by LaunchQL roles launchql-ext-default-roles Security launchql-ext-jobs-queueExtensionsExtensionsFeatures · ExtensionsTransactional SQL job queues and scheduled jobs for external workers queue jobs launchql-ext-jobs-queue Features launchql-ext-typesExtensionsExtensionsData types · Extensions🛠. basic pg utils launchql-ext-types Data types