Search PostgreSQL documentation

bitemp_retrievalExtensionsExtensionsRetrieval, coalescing, and join helpers for bitemporal tables created by pg_bitemporal. bitemp_retrieval Time seriesTime series · Extensions bitmap_counterExtensionsExtensionsAggregation functions and data type for distinct estimation based on s-bitmap. aggregate bitmap count distinct estimate self-learning distinct_estimators Functions and aggregatesFunctions and aggregates · Extensions bitpolar_pgExtensionsExtensionsBitPolar: near-optimal vector quantization — 3-8 bit compression with zero training. 58 integrations across every major AI framework. bitpolar_pg AI and vectorsAI and vectors · Extensions bitstring_helpersExtensionsExtensionsHelper C functions and aggregates for PostgreSQL bit varying data. bit-string hamming-distance bitstring_helpers Functions and aggregatesFunctions and aggregates · Extensions bktreeExtensionsExtensionsSP-GiST BK-tree index extension for 64-bit perceptual hashes and Hamming-distance searches. bk-tree hamming-distance index spgist bktree AI and vectorsAI and vectors · Extensions blake2bExtensionsExtensionsPostgreSQL extension for fast secure hashing blake2b cardano cryptography postgresql-extension blake2b SecuritySecurity · Extensions block_copy_commandExtensionsExtensionsBlock COPY commands via a configurable ProcessUtility hook pgrx block_copy_command SecuritySecurity · Extensions bloomExtensionsPG18F.6. bloom — bloom filter index access method bloom provides an index access method based on Bloom filters. A Bloom filter is a space-efficient data structure that is used to test whether an…bloom — bloom filter index access method bloom_fulonExtensionsExtensionsExperimental pgrx index access method for PostgreSQL, created for learning purposes. experimental index pgrx bloom_fulon FeaturesFeatures · Extensions bloompgExtensionsExtensionsPlanner-hook extension for PostgreSQL 18 that prefilters equality-join inputs with adaptive Bloom or exact bitmap transfer before replanning analytical queries. analytics bloom-filter join-o…Features · Extensions bluefinExtensionsExtensionsAppend-only compressed table access method for time-series workloads. table-am columnar compression timeseries advanced_storage_pack AnalyticsAnalytics · Extensions bobbie@helloExtensionsExtensionsAn extension to generate greetings database.dev tle bobbie@hello Functions and aggregatesFunctions and aggregates · Extensions bool_plperlExtensionsExtensionstransform between bool and plperl plperl Procedural languagesProcedural languages · Extensions bool_plperluExtensionsExtensionstransform between bool and plperlu plperlu Procedural languagesProcedural languages · Extensions boolean_cascadedExtensionsExtensionsComposite boolean status type with operators and trigger helper for cascaded parent-child status. boolean data-type trigger boolean_cascaded Data typesData types · Extensions brainfuckExtensionsExtensionsRun Brainfuck programs inside PostgreSQL using a PLV8 trusted language extension. brainfuck plv8 tle brainfuck Procedural languagesProcedural languages · Extensions brinExtensionsPG1865.5. BRIN IndexesBRIN Indexes brin4postgisExtensionsExtensionsBRIN indexes for PostGIS brin experimental geometry index postgis brin4postgis GeospatialGeospatial · Extensions btreeExtensionsPG1865.1. B-Tree IndexesB-Tree Indexes btree_ginExtensionsPG18F.7. btree_gin — GIN operator classes with B-tree behavior btree_gin provides GIN operator classes that implement B-tree equivalent behavior for the data types int2, int4, int8, float4, floa…btree_gin — GIN operator classes with B-tree behavior btree_gistExtensionsPG18F.8. btree_gist — GiST operator classes with B-tree behavior btree_gist provides GiST index operator classes that implement B-tree equivalent behavior for the data types int2, int4, int8, fl…btree_gist — GiST operator classes with B-tree behavior buffercache_toolsExtensionsExtensionsInspect and manipulate PostgreSQL buffer cache entries for relations, forks, databases, and tablespaces. buffer-cache inspection maintenance buffercache_tools AdministrationAdministration · Extensions bundleExtensionsExtensionsdata version control system events plpgsql postgresql rest-api semantics system-catalog version-control-system widgets bundle FeaturesFeatures · Extensions busybee_fdwExtensionsExtensionsMQTT Foreign Data Wrapper busybee_fdw Foreign data wrappersForeign data wrappers · Extensions bwcontrolExtensionsExtensionsBottledwater control extension bottledwater cdc kafka replication bwcontrol Replication and streamsReplication and streams · Extensions bytea_exifExtensionsExtensionsPostgreSQL extension for EXIF data reading from bytea value of image and MIME type check exif exif-metadata image-exif mime-types postgis postgres postgresql postgresql-extension spatial-ana…Utilities · Extensions bytea_plphpExtensionsExtensionsBinary-safe transform between bytea and PHP strings for PL/php bytea binary php transform plphp Procedural languagesProcedural languages · Extensions byteamagicExtensionsExtensionsDetect MIME types and file formats from PostgreSQL bytea values pg_byteamagic UtilitiesUtilities · Extensions bzipExtensionsExtensionsBzip compression and decompression pg_bzip UtilitiesUtilities · Extensions bztreeExtensionsExtensionsBzTree index access method with equality operator classes for common PostgreSQL scalar types. bztree index-access-method bztree FeaturesFeatures · Extensions cadfixExtensionsExtensionsOCC interface implementation in JavaScript cadfix FeaturesFeatures · Extensions cairn_pgxExtensionsExtensionsCairn in-database verify gate — COSE Sign1/Ed25519 event verification (Spike 0002) pgrx rust cairn_pgx SecuritySecurity · Extensions calculate_markupExtensionsExtensionsC function that calculates a price markup percentage by linear interpolation over a numeric price/markup array. linear-interpolation pricing calculate_markup Functions and aggregatesFunctions and aggregates · Extensions calendarsExtensionsExtensionscalendar conversion routines calendar conversion calendars Time seriesTime series · Extensions call_graphExtensionsExtensionsTrack PostgreSQL function calls automatically and aggregate them into call graphs and optional table-usage statistics. call-graph function-tracing statistics call_graph MonitoringMonitoring · Extensions capitalizeExtensionsExtensionsA function to capitalize all the given character capitalize Functions and aggregatesFunctions and aggregates · Extensions cart_extExtensionsExtensionsCart-service transaction markers and LISTEN/NOTIFY background workers for a marketplace prototype. cart_ext FeaturesFeatures · Extensions cartodbExtensionsExtensionsArchived PostgreSQL extension for turning a database into a CartoDB user database. cartodb-postgresql GeospatialGeospatial · Extensions casExtensionsExtensionsCAS Registry Number data type for PostgreSQL. cas-registry-number data-type cas Data typesData types · Extensions cas_codesExtensionsExtensionsCAS Registry Number data type and validation support for PostgreSQL. cas-number chemistry data-type pgrx emi_monorepo Data typesData types · Extensions