Search PostgreSQL documentation

eventExtensionsExtensionspub/sub data change event tracking system events plpgsql postgresql rest-api semantics system-catalog version-control-system widgets event FeaturesFeatures · Extensions event_managerExtensionsExtensionsLoosely coupled PostgreSQL event trigger and queue system with synchronous or asynchronous processing. async event-trigger listen-notify queue event_manager FeaturesFeatures · Extensions evrExtensionsExtensionsPostgreSQL extension for RPM epoch/version/release datatype parsing. postgresql_evr Data typesData types · Extensions explain_uiExtensionsExtensionseasily jump into a visual plan UI for any SQL query pgrx nil-lic pg_explain_ui MonitoringMonitoring · Extensions explanationExtensionsExtensionsEXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree. analyze explain explain-analyze node plan statistics table xml explanation MonitoringMonitoring · Extensions exploring_aggregatesExtensionsExtensionspgrx example defining a custom integer-sum aggregate with serialized state. exploring_aggregates Functions and aggregatesFunctions and aggregates · Extensions ext3ExtensionsExtensionsClientAuthentication hook example that logs authentication start and end events. ext3 SecuritySecurity · Extensions extension_dropExtensionsExtensionsRun custom commands when an extension is dropped. extension extension development extensions extension_drop AdministrationAdministration · Extensions external_fileExtensionsExtensionsAccess external server-side files through PostgreSQL functions external_file UtilitiesUtilities · Extensions external_search_fdwExtensionsExtensionsAlloyDB extension that provides a read-only foreign data wrapper for querying Elasticsearch data from PostgreSQL. alloydb elasticsearch fdw search external_search_fdw Foreign data wrappersForeign data wrappers · Extensions extra_window_functionsExtensionsExtensionsExtra Window Functions for PostgreSQL extra_window_functions Functions and aggregatesFunctions and aggregates · Extensions extremaExtensionsExtensionsPostgreSQL extension to control resource usage of other extensions' bgworkers extrema AdministrationAdministration · Extensions fakerExtensionsExtensionsWrapper for the Faker Python library test faker Procedural languagesProcedural languages · Extensions fakesetExtensionsExtensionspostgres extension to generate fake sentences fakeset Functions and aggregatesFunctions and aggregates · Extensions falconExtensionsExtensionsFalconFS is a high-performance distributed file system (DFS) designed for AI workloads. falcon AnalyticsAnalytics · Extensions fast_guidExtensionsExtensionsFast GUID generator function for PostgreSQL. postgresql_fast_guid Functions and aggregatesFunctions and aggregates · Extensions fasttrunExtensionsExtensionsOptimezed fasttruncate extension for 1C:Enterprise 8 fasttrun AdministrationAdministration · Extensions fbsqlExtensionsExtensionsClosure-preserving formula-based statistical modeling in SQL statistics glm machine-learning plr fbsql Functions and aggregatesFunctions and aggregates · Extensions festivalExtensionsExtensionsFESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices dataset-generation flash-memory postgis-extension postgresql-extension r-trees spatial-index fest…Geospatial · Extensions fetchqExtensionsExtensionsPostgres extension that enables FetchQ capabilities fetchq FeaturesFeatures · Extensions fft_approximateExtensionsExtensionsFFT-based approximate aggregate range queries over time-series data. fft timeseries approximate aggregate fft_approximate Functions and aggregatesFunctions and aggregates · Extensions fhir_jsonbExtensionsExtensionsSynthetic FHIR JSONB data generator and query benchmark fixture for PostgreSQL. benchmark fhir jsonb synthetic-data fhir_jsonb Functions and aggregatesFunctions and aggregates · Extensions fhirbaseExtensionsExtensionsIncomplete PostgreSQL extension scaffold for a FHIR database. fhir healthcare json xml fhirbase FeaturesFeatures · Extensions fhirpathExtensionsExtensionsdata type for jsonb inspection fhirpath_pg FeaturesFeatures · Extensions fibonacciExtensionsExtensionsFibonacci extension for PostgreSQL. fibonacci Functions and aggregatesFunctions and aggregates · Extensions file_fdwExtensionsPG18F.15. file_fdw — access data files in the server's file system The file_fdw module provides the foreign-data wrapper file_fdw, which can be used to access data files in the server's file sys…file_fdw — access data files in the server's file system file_fdw_programExtensionsExtensionsBackport of file_fdw PROGRAM support, exposing a file_fdw-like foreign data wrapper that reads from external commands. backport fdw file program file_fdw_program Foreign data wrappersForeign data wrappers · Extensions file_fixed_length_fdwExtensionsExtensionsForeign data wrapper for files with fixed-length fields. fdw file fixed-length file_fixed_length_fdw Foreign data wrappersForeign data wrappers · Extensions file_textarray_fdwExtensionsExtensionsForeign data wrapper returning each text-file row as a text array. csv fdw file text-array file_textarray_fdw Foreign data wrappersForeign data wrappers · Extensions filenode_map_inspectExtensionsExtensionsCheck and examine pg_filenode.map files filenode_map_inspect AdministrationAdministration · Extensions filesystemExtensionsExtensionsfilesystem foreign data wrapper events plpgsql postgresql rest-api semantics system-catalog version-control-system widgets filesystem Foreign data wrappersForeign data wrappers · Extensions financialExtensionsExtensionsFinancial aggregate functions pg_financial Functions and aggregatesFunctions and aggregates · Extensions find_bucket_tsExtensionsExtensionsArtifacts of BaCon. For VLDB26 reviewers only. find_bucket_ts Time seriesTime series · Extensions fioExtensionsExtensionsPostgreSQL File I/O Functions pg_fio AdministrationAdministration · Extensions firebird_fdwExtensionsExtensionsForeign data wrapper for Firebird firebird_fdw Foreign data wrappersForeign data wrappers · Extensions fireflyExtensionsExtensionsPostGIS-backed Firefly database schema for tracking 3D points and add/delete operations by task. firefly geometry point3d postgis firefly_database GeospatialGeospatial · Extensions first_lastExtensionsExtensionsAggregate functions to return first or last "n" elements in a group aggregate first last first_last Functions and aggregatesFunctions and aggregates · Extensions first_last_aggExtensionsExtensionsfirst() and last() aggregate functions first_last_agg Functions and aggregatesFunctions and aggregates · Extensions fixeddecimalExtensionsExtensionsFixed-precision decimal type optimized for performance and storage. data-type fixed-decimal numeric fixeddecimal Data typesData types · Extensions flameExtensionsExtensionsPGRX proof-of-concept extension that generates text embeddings with fastembed/MiniLM. embedding pgrx rag flame AI and vectorsAI and vectors · Extensions