Search PostgreSQL documentation

kafkaExtensionsExtensionsProduce messages to Apache Kafka from PostgreSQL kafka messaging preload pg_kafka Replication and streamsReplication and streams · Extensions kafka_fdwExtensionsExtensionskafka Foreign Data Wrapper for CSV formatted messages kafka_fdw Foreign data wrappersForeign data wrappers · Extensions Kernel Resource UsageManual ChaptersPG1819.4.3. Kernel Resource Usage max_files_per_process (integer) # Sets the maximum number of open files each server subprocess is allowed to open simultaneously; files already opened in the po…Kernel Resource Usage key_column_usageManual ChaptersPG1835.32. key_column_usage The 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…key_column_usage keyhippoExtensionsExtensionsRLS-compatible API keys for PostgreSQL auth rls roles supabase tle keyhippo SecuritySecurity · Extensions Keyword/Value Connection StringsManual ChaptersPG1832.1.1.1. Keyword/Value Connection Strings In the keyword/value format, each parameter setting is in the form keyword = value, with space(s) between settings. Spaces around a setting's equal…Keyword/Value Connection Strings kham_pgExtensionsExtensionsThai word-segmentation FTS parser — tsvector, soundex, RTGS romanization, NER fts named-entity nlp parser romanization soundex thai tokenizer kham_pg Full-text searchFull-text search · Extensions khulnasoft_vaultExtensionsExtensionsKhulnasoft Vault Extension khulnasoft_vault SecuritySecurity · Extensions kilobaseExtensionsExtensionsPreloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views. background-worker materialized-view pgrx scheduling kilobase Time seriesTime series · Extensions kissfftExtensionsExtensionsFast-Fourier transformer (fft) aggregate fft fourier pgfft Functions and aggregatesFunctions and aggregates · Extensions kiwicopple-is_evenExtensionsExtensionsCalculates if a value is even. database.dev tle kiwicopple-is_even Functions and aggregatesFunctions and aggregates · Extensions kmeaExtensionsExtensionsK-Mer Extension for Analysis kmea Data typesData types · Extensions kmeansExtensionsExtensionsK-means clustering window function for PostgreSQL analysis clustering k-means statistics window-function kmeans AI and vectorsAI and vectors · Extensions kmoneyExtensionsExtensionsExact scale-18 monetary types with one SQL type per currency. money currency fixed-point iso-4217 kamu-money-pg Data typesData types · Extensions knxExtensionsExtensionsdata types for KNX Addresses address datatype knx pgknx Data typesData types · Extensions koldstoreExtensionsExtensionsPostgreSQL 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…Analytics · Extensions konfigrafExtensionsExtensionsGit based application configuration config configuration git konfigraf FeaturesFeatures · Extensions kor_searchExtensionsExtensionsA PostgreSQL extension for Korean-English text search. english fts korean similarity synonyms kor_search Full-text searchFull-text search · Extensions kq_cxExtensionsExtensionsPreloaded in-memory calendar cache and date-arithmetic functions for ketteQ PostgreSQL schemas. cache calendar pgrx preload kq_cx Time seriesTime series · Extensions kq_fxExtensionsExtensionsketteQ, Inc. currency fx pgrx kq_fx Functions and aggregatesFunctions and aggregates · Extensions krb_caseins_usersConfigurationReferencekrb_caseins_users Connections and Authentication 10 Sets whether GSSAPI user names should be treated case-insensitively. The default is off (case sensitive). This parameter can only be set i…Configuration · Connections and Authentication krb_server_keyfileConfigurationReferencekrb_server_keyfile Connections and Authentication 10 Sets the location of the Kerberos server key file. See Section 20.3.3 for details. This parameter can only be set in the postgresql.conf …Configuration · Connections and Authentication krb_srvnameConfigurationReferencekrb_srvname Connections and Authentication 9.0 Sets the Kerberos service name. See Section 19.3.5 for details. This parameter can only be set in the postgresql.conf file or on the server com…Configuration · Connections and Authentication krbsrvnameCommand-line ToolsPG18krbsrvname Kerberos service name to use when authenticating with GSSAPI. This must match the service name specified in the server configuration for Kerberos authentication to succeed. (See a…Database Connection Control Functions › Parameter Key Words ksjExtensionsExtensionsJapanese kanji-numeral integer type with arithmetic, aggregates, casts, comparison, and B-tree indexing integer japanese kanji numeric ksj Data typesData types · Extensions kt_fdwExtensionsExtensionsForeign data wrapper for reading and writing Kyoto Tycoon key-value stores. fdw kyoto-tycoon kt_fdw Foreign data wrappersForeign data wrappers · Extensions kv_fdwExtensionsExtensionsForeign data wrapper for key-value storage backed by RocksDB/VidarDB. fdw key-value rocksdb kv_fdw Foreign data wrappersForeign data wrappers · Extensions l10n_table_dependent_extensionExtensionsExtensionsPostgreSQL l10n toolbox pg_xenophile Data typesData types · Extensions lab-ordersExtensionsExtensionspgpm demo for the Postgres Conference 2026 lab-orders FeaturesFeatures · Extensions lagFunctionsReferencelag Window Functions 10 returns value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead return default (which must be of …Functions · Window Functions lambdaExtensionsExtensionsLambda function for Postgres function functions lambda plpgsql pg_lambda Procedural languagesProcedural languages · Extensions lanceExtensionsExtensionsPostgreSQL FDW extension for reading and querying Lance format tables arrow fdw lance pgrx lance Foreign data wrappersForeign data wrappers · Extensions languageExtensionsExtensionsCustom PostgreSQL language enumeration type enum language type pg_language Data typesData types · Extensions Language TagManual ChaptersPG1823.1.5.3. Language Tag A 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 simp…Language Tag language_handlerData TypesPG18language_handler A procedural language call handler is declared to return language_handler.Pseudo-Types lantern_extrasExtensionsExtensionsConvenience functions for working with vector embeddings ai embeddings llm pgrx vector lantern_extras AI and vectorsAI and vectors · Extensions Large ObjectsManual ChaptersPG1834.12. Large Objects Large objects are not directly supported by ECPG, but ECPG application can manipulate large objects through the libpq large object functions, obtaining the necessary PGc…Large Objects Large ObjectsManual ChaptersPG18Chapter 33. Large Objects PostgreSQL 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 usef…Large Objects last_valueFunctionsReferencelast_value Window Functions 10 returns value evaluated at the row that is the last row of the window frame last_value ( value any ) → same type as value returns value evaluated at the row th…Functions · Window Functions lastvalFunctionsReferencelastval Sequence Manipulation Functions 10 Return value most recently obtained with nextval for any sequence lastval ( ) → bigint Return value most recently obtained with nextval for any seq…Functions · Sequence Manipulation Functions