select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_hashids · Short unique id generator for PostgreSQL, using hashids · 1.3 · Functions and aggregates · MIT · C · Packagedpg_blkchain · C extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. · 0.0.1 · Functions and aggregates · MIT · C · Not packagedeva_pg · EVA ICS pgrx extension for the EVA industrial IoT platform. · 0.0.1 · Functions and aggregates · Apache-2.0 · Rust · Not packagedpg_sqids · Encode numbers as short URL-safe Sqids and decode them in PostgreSQL · 0.1.0 · Functions and aggregates · MIT · Rust · Not packageduuidv7-sql · Pure SQL and PL/pgSQL functions for generating, inspecting, and transforming UUID version 7 values. · 1.1 · Functions and aggregates · PostgreSQL · SQL · Not packageddatasketches · Approximate analytics sketches and aggregates for PostgreSQL · 1.7.0 · Functions and aggregates · Apache-2.0 · C++ · Packagedsnowflake · Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL · 2.5.0 · Functions and aggregates · PostgreSQL · C · Packageduids · PostgreSQL extension to generate various types of universally unique IDs · 0.0.1 · Functions and aggregates · Unknown · Rust · Not packagedpg_ulid · Generate ULID strings in PostgreSQL with a C function. · 0.0.4 · Functions and aggregates · Unknown · C · Not packagedpermuteseq · Pseudo-randomly permute sequences with a format-preserving encryption on elements · 1.2.2 · Functions and aggregates · PostgreSQL · C · Packagedpgflake · Extension for fdw memory · 0.0.1 · Functions and aggregates · Apache-2.0 · C · Not packagedfirst_last_agg · first() and last() aggregate functions · 0.1.4 · Functions and aggregates · PostgreSQL · C · Packagedjsonbx · Jsonb extension functions for PostgreSQL 9.4 · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedextra_window_functions · Extra Window Functions for PostgreSQL · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedpg_xid · PostgreSQL extension exposing xid generation functions · 1.0 · Functions and aggregates · MIT · C · Not packagedfinancial · Financial aggregate functions · 1.0.1 · Functions and aggregates · PostgreSQL · C · Packagedargm · argmax, argmin, and anyold aggregate functions · 1.1.1 · Functions and aggregates · PostgreSQL · C · Packagedrange_agg · range_agg: merge adjacent or overlapping PostgreSQL range values · 1.2.1 · Functions and aggregates · MIT · C · Not packagedjsonknife · Useful jsonb inspection and transformation functions · 1.0 · Functions and aggregates · Unknown · C · Not packagedjson_build · C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. · 1.1.0 · Functions and aggregates · PostgreSQL · C · Not packagedparray_gin · GIN index operator class and partial-match operators for text arrays · 1.5.0 · Functions and aggregates · PostgreSQL · C · Packagedpg_math · GSL statistical functions for postgresql · 1.1.0 · Functions and aggregates · GPL-3.0 · C · Packagedpg_normalize_query · Normalize constants in SQL statements using PostgreSQL parser logic · 1.0 · Functions and aggregates · BSD-3-Clause · C · Not packagedbitmap_counter · Aggregation functions and data type for distinct estimation based on s-bitmap. · 1.3.5 · Functions and aggregates · BSD-3-Clause · C · Not packagedloglog_counter · Aggregation functions and data type for distinct estimation based on LogLog. · 1.2.4 · Functions and aggregates · BSD-2-Clause · C · Not packagedacoustid · PostgreSQL extension for working with AcoustID fingerprints · 1.0 · Functions and aggregates · Unknown · C · Not packagedpg_url · Implements URL handling methods as postgres extension · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedweighted_mean · Weighted average aggregate function for PostgreSQL numeric values. · 1.0.1 · Functions and aggregates · PostgreSQL · C · Not packagedcolors · C functions for perceptual color-distance calculations in the CIE L*a*b* color space · 0.0.1 · Functions and aggregates · PostgreSQL · C · Not packagedslugify · PostgreSQL Extension to generate various variant of Slugs from a string. · 0.0.1 · Functions and aggregates · MIT · Rust · Not packagedpg_testgen · Generate random integers, strings, and test-data rows for PostgreSQL development · 1.0 · Functions and aggregates · Unknown · C · Not packagedpgrx_validation · Cross-target Rust validation library compiled as PostgreSQL functions through an optional pgrx feature. · 0.0.0 · Functions and aggregates · GPL-3.0 · Rust · Not packagedcolnames · Lists the column names in a PostgreSQL RECORD value · 1.7.0 · Functions and aggregates · PostgreSQL · C · Not packagedhash64 · Stable 64-bit hash function whose results do not change across PostgreSQL major versions. · 0.1.0 · Functions and aggregates · PostgreSQL · C · Not packagedjson_accessors · JSON accessor functions · 1.3.6 · Functions and aggregates · PostgreSQL · C · Not packagedjson_query · Generate PostgreSQL WHERE clause predicates from JSONB filter objects. · 0.9 · Functions and aggregates · PostgreSQL · SQL · Not packagedpgaut · Auto Update Timestamp for PostgreSQL · 1.0.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedpg_rowalesce · rowalesce() is like coalesce(), but for rows and other composite types. · 0.1.12 · Functions and aggregates · PostgreSQL · SQL · Not packagedpopcount · provide population-count functions for PostgreSQL bit(n) values · 1.0.0 · Functions and aggregates · MIT · C · Not packagedpg_ta · TA-Lib technical-analysis functions exposed as PostgreSQL functions · 1.0 · Functions and aggregates · BSD-2-Clause · C · Not packagedpsl · Returns the registrable domain for a hostname using a compiled-in Public Suffix List. · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packagedshbf · C extension providing Bloom filter, shifting Bloom filter, and count-min sketch PostgreSQL data types and functions. · 1.0.0 · Functions and aggregates · Unknown · C · Not packageduuid-freebsd · UUID generation functions for PostgreSQL on FreeBSD. · 2.0 · Functions and aggregates · PostgreSQL · C · Not packagedfnvhash · FNV hash functions for PostgreSQL. · 1.0 · Functions and aggregates · Unknown · C · Not packagedlaunchql-inflection · inflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL · 0.0.2 · Functions and aggregates · MIT · C · Not packagednatord_pg · Natural-order comparison operators and btree operator class for PostgreSQL text values. · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedpg_accumulator · Accumulation registers for balance and turnover tracking in PostgreSQL · 1.1.3 · Functions and aggregates · PostgreSQL · C · Packagedpg_hist · Compute fast weighted or unweighted histograms in one or more dimensions. · 1.0.0 · Functions and aggregates · GPL-2.0 · C · Not packagedpgfaker · Generates fake company, person, internet, and phone data in PostgreSQL for tests, performance testing, and demos. · 0.0.3 · Functions and aggregates · MIT · Rust · Not packagedpltoolbox · provide C utility functions for PostgreSQL stored procedures · 1.0.3 · Functions and aggregates · BSD-2-Clause · C · Not packagedcidr · Transform an IPv4 or IPv6 address range into the minimal set of CIDR blocks · 1.0 · Functions and aggregates · MIT · SQL · Not packagedformat · A string formatting function which takes named parameters · 0.0.1 · Functions and aggregates · MIT · C · Not packagedkissfft · Fast-Fourier transformer (fft) · 0.0.1 · Functions and aggregates · PostgreSQL · C · Not packagedpg_ethopic · Format Ethiopic dates and numbers in PostgreSQL. · 0.0.1 · Functions and aggregates · MIT · Rust · Not packagedunnest_ordinality · Legacy array unnest function that returns each element with its ordinal position. · 1.0.1 · Functions and aggregates · PostgreSQL · C · Not packagedvihash · version-independent hash functions · 1 · Functions and aggregates · PostgreSQL · C · Not packagedbase62 · Base62 extension for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · C · Packagedmerge_ips · Functions to merge IP addresses, ignoring gaps · 1.0 · Functions and aggregates · PostgreSQL · SQL · Not packagednextid · Generate Instagram-style sharded integer IDs. · 0.1 · Functions and aggregates · MIT · C · Not packagednfiesta · PostgreSQL extension implementing nFIESTA forest inventory estimation functionality. · 5.0.0 · Functions and aggregates · EUPL-1.2 · SQL · Not packagednumpgsql · Array and numerical computing library for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · C++ · Not packagedpg_aa · ASCII art extension for PostgreSQL · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedpg_array_multi_index · simultaneous multiple-indexing of PostgreSQL arrays · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedpg_bedtools_rs · A PostgreSQL plugin for bedtools, implemented in Rust. · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedpg_gsl · Wraps selected GNU Scientific Library routines, including real FFT transforms and helper functions, for PostgreSQL. · 0.0.2 · Functions and aggregates · GPL-3.0 · C · Not packagedpg_normalize_email · Normalize email addresses in PostgreSQL · 1.0.9 · Functions and aggregates · PostgreSQL · SQL · Not packagedpg_purr · A PostgreSQL extension (via PL/Python) that brings quantum computing capabilities. · 0.2.0 · Functions and aggregates · MIT · Python · Not packagedpg_uuid_v8 · UUID v8 generator with embedded timestamps for PostgreSQL · 1.1.0 · Functions and aggregates · PostgreSQL · C · Packagedshort_ids · PL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks. · 0.1.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedtanimoto · Fast C implementation of the Tanimoto similarity coefficient for PostgreSQL bit-varying fingerprints. · 1.0 · Functions and aggregates · Unknown · C · Not packagedweighted_statistics · High-performance weighted statistics functions for sparse data · 1.0.0 · Functions and aggregates · PostgreSQL · C · Packagedddsketch · Provides ddsketch aggregate function · 1.0.1 · Functions and aggregates · PostgreSQL · C · Packagedfast_guid · Fast GUID generator function for PostgreSQL. · 0.1 · Functions and aggregates · PostgreSQL · C · Not packagedfibonacci · Fibonacci extension for PostgreSQL. · 0.0.2 · Functions and aggregates · GPL-2.0 · C · Not packagedgenerate_date_series · generate_series()-style set-returning function for date ranges with integer day steps. · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packagedjson_utils · JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+. · 0.1 · Functions and aggregates · PostgreSQL · SQL · Not packagedjsonb_set_lax · Backport of PostgreSQL 13 jsonb_set_lax for PostgreSQL 9.5 through 12 · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packagedlibuuid · Generate UUIDs through the system libuuid library · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedpcg_random · PCG pseudo-random number generator functions for PostgreSQL. · 0.0.1 · Functions and aggregates · Apache-2.0 · C · Not packagedpg_base58 · Base58 Encoder/Decoder Extension for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · Rust · Packagedpg_median_utils · Median filter and iterative median filter window functions for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · C · Not packagedpg_sample_ext · A Sample PostgreSQL extension · 1.0.2 · Functions and aggregates · PostgreSQL · SQL · Not packagedpg_str · Add Laravel-inspired string manipulation functions to PostgreSQL using pgrx · 0.3.1 · Functions and aggregates · MIT · Rust · Not packagedpg_strverscmp · Natural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order. · 1.0 · Functions and aggregates · ISC · C · Not packagedpgpm-faker · PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. · 0.15.5 · Functions and aggregates · MIT · C · Not packagedpgpm-inflection · PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. · 0.30.0 · Functions and aggregates · MIT · C · Not packagedproven · proven: PostgreSQL C bindings for formally verified safety functions from libproven · 0.5.0 · Functions and aggregates · MPL-2.0 · C · Not packagedvalidadores · Brazilian CPF check-digit validator, operator, and domain · 0.0.2 · Functions and aggregates · PostgreSQL · SQL · Not packagedapprox_count · Fast approximate row counts for tables and indexes in PostgreSQL 14+ from pg class.reltuples, with a governed ANALYZE refresh · 1.0 · Functions and aggregates · Unknown · SQL · Not packagedarray_concat · aggregates and functions for PostgreSQL Server · 1.0 · Functions and aggregates · Unknown · C · Not packagedbitstring_helpers · Helper C functions and aggregates for PostgreSQL bit varying data. · 1.0 · Functions and aggregates · Unknown · C · Not packagedcmath · C11 math functions exposed to PostgreSQL with C-backed implementations. · 1.2 · Functions and aggregates · GPL-3.0 · C · Not packagedcomposite · aggregates and functions for PostgreSQL Server · 1.0 · Functions and aggregates · Unknown · C · Not packagedcount_char · aggregates and functions for PostgreSQL Server · 1.0 · Functions and aggregates · Unknown · C · Not packagedfhir_jsonb · Synthetic FHIR JSONB data generator and query benchmark fixture for PostgreSQL. · 1.0 · Functions and aggregates · Unknown · SQL · Not packagedget_column · Fetch a column value from a record by name · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packagedhtc · Horvitz-Thompson continuous-population estimator functions for PostgreSQL. · 2.1 · Functions and aggregates · EUPL-1.2 · C · Not packagedinsert_array · aggregates and functions for PostgreSQL Server · 1.0 · Functions and aggregates · Unknown · C · Not packagedkq_fx · ketteQ, Inc. · 1.0.1 · Functions and aggregates · Apache-2.0 · Rust · Not packagedmean · aggregates and functions for PostgreSQL Server · 1.0 · Functions and aggregates · Unknown · C · Not packagedmin_to_max · aggregates and functions for PostgreSQL Server · 1.0 · Functions and aggregates · Unknown · C · Not packagedpg_calcpi · Computes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm. · 1.0 · Functions and aggregates · Unknown · SQL · Not packagedpg_json_diff · JSONB diff, JSON Patch, and merge-patch functions for PostgreSQL · 1.0 · Functions and aggregates · MIT · C++ · Not packagedpg_open_meteo · Prototype Rust/pgrx PostgreSQL extension associated with Open-Meteo weather data. · 0.0.0 · Functions and aggregates · Unknown · Rust · Not packagedpg_ortools · Constraint optimization extension using the HiGHS MIP/LP solver from PostgreSQL, with optional async execution. · 0.2.0 · Functions and aggregates · Matroid · Rust · Not packagedpg_py_ext · A PostgreSQL extension using PL/Python3U to add numbers · 1.0.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedpg_rand_ext · Functions that generate random values for PostgreSQL · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedpg_snowid · Generate thread-safe, time-sorted Snowflake-like IDs in PostgreSQL · 3.1.0 · Functions and aggregates · MIT · Rust · Not packagedpg_variant_functions · Variant summary and allele-frequency functions over TINYINT[] genotype arrays · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedpgx_uuidv7 · A PostgreSQL extension to generate and cast v7 UUIDs · 0.1.7 · Functions and aggregates · MIT · Rust · Not packagedrandom · random data generator · 2.0.0 · Functions and aggregates · PostgreSQL · C · Packagedrecommend · Experimental C extension providing scalar distance, text similarity, and one-dimensional array similarity functions derived from smlar. · 1.0 · Functions and aggregates · Unknown · C · Not packagedrotate_array · aggregates and functions for PostgreSQL Server · 1.0 · Functions and aggregates · Unknown · C · Not packagedsplit_composite · aggregates and functions for PostgreSQL Server · 1.0 · Functions and aggregates · Unknown · C · Not packagedstringtheory · C++ extension providing SIMD-optimized exact equality and substring-search functions for PostgreSQL text values. · 1.0.2 · Functions and aggregates · PostgreSQL · C++ · Not packagedsum_array · C function that sums PostgreSQL integer and floating-point arrays into float8. · 0.0.1 · Functions and aggregates · Unknown · C · Not packagedweighted_stats · Weighted aggregate functions · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packagedxata_id_extension · Generate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix. · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedI4R_AUDB_extension · AUDB operations for PostgreSQL int4range values. · 1.1 · Functions and aggregates · Unknown · C · Not packagedauto_counters · PostgreSQL extension for automatic contextual numbering · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedautoinc · functions for autoincrementing fields · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedbgvalidators · Validation functions for IBAN, Bulgarian EGN personal IDs, BULSTAT VAT numbers, and LNCh foreigner IDs. · 1.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedbtree_gin · support for indexing common datatypes in GIN · 1.3 · Functions and aggregates · PostgreSQL · C · Packagedbtree_gist · support for indexing common datatypes in GiST · 1.7 · Functions and aggregates · PostgreSQL · C · Packagedcountnulls · Simple function to count the number of NULL arguments · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packageddbstats · Descriptive statistics and data quality analysis for PostgreSQL · 1.1 · Functions and aggregates · Unknown · SQL · Not packageddict_int · text search dictionary template for integers · 1.0 · Functions and aggregates · PostgreSQL · C · Packageddict_xsyn · text search dictionary template for extended synonym processing · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedfirst_last · Aggregate functions to return first or last "n" elements in a group · 0.1.1 · Functions and aggregates · PostgreSQL · SQL · Not packagedgenerate_up_down_series · PostgreSQL Up Down Sequence · 0.0.1 · Functions and aggregates · Unknown · C · Not packagedget_sum · simple sum of two integers for postgres externsion using c · 0.0.1 · Functions and aggregates · Unknown · C · Not packagedinsert_username · functions for tracking who changed a table · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedintagg · integer aggregator and enumerator (obsolete) · 1.1 · Functions and aggregates · PostgreSQL · C · Packagedintarray · functions, operators, and index support for 1-D arrays of integers · 1.5 · Functions and aggregates · PostgreSQL · C · Packagedmoddatetime · functions for tracking last modification time · 1.0 · Functions and aggregates · PostgreSQL · C · Packagednfiesta_sdesign · PostgreSQL extension for manipulating sampling design data. · 1.1.17 · Functions and aggregates · EUPL-1.2 · SQL · Not packagedomnisketch · data structure for on-line agg of data into approximate sketch · 1.0.2 · Functions and aggregates · PostgreSQL · C · Packagedpg_cext · A PostgreSQL extension to add two numbers · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packagedpg_jsonpatch · PostgreSQL implementation of JSON Patch · 1.0.0 · Functions and aggregates · MIT · SQL · Not packagedpg_kalman · A Kalman filter extension for PostgreSQL. · 0.1 · Functions and aggregates · Unknown · C · Not packagedpg_plpgsql_ext · A PostgreSQL extension with a PL/pgSQL function to subtract numbers · 1.0.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedpg_running_stats · Mergeable Running Statistics (Welford/Chan) Extension for PostgreSQL · 1.0 · Functions and aggregates · MIT · C · Not packagedpg_snowflake_id · Snowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx · 0.0.1 · Functions and aggregates · MIT · Rust · Not packagedpgcuid2 · Generate CUID2 text identifiers inside PostgreSQL using the cuid2 Rust crate. · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedpgrand · Generates random test data through a PostgreSQL FDW, with an experimental table access method. · 0.1.0 · Functions and aggregates · Unknown · Rust · Not packagedpgrx_jsonb · Proof-of-concept pgrx functions for iterating PostgreSQL JSONB internals and reconstructing JSON values · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedpksuid · generate prefixed, sortable KSUID identifiers in PostgreSQL · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedrange_type_functions · Functions for enhancing range type functionality. · 0.0.4 · Functions and aggregates · PostgreSQL · SQL · Not packagedrefint · functions for implementing referential integrity (obsolete) · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedsession_hash_tools · Functions to store nested hashes in PL/Perl shared hash · 1.0.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedtcn · Triggered change notifications · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedtsm_system_rows · TABLESAMPLE method which accepts number of rows as a limit · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedtsm_system_time · TABLESAMPLE method which accepts time in milliseconds as a limit · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedunaccent · text search dictionary that removes accents · 1.1 · Functions and aggregates · PostgreSQL · C · Packageduuid-ossp · generate universally unique identifiers (UUIDs) · 1.1 · Functions and aggregates · PostgreSQL · C · Packagedvarbitx · Alibaba Cloud RDS bitmap function extension for additional varbit operations · 1.0 · Functions and aggregates · Unknown · C · Not packaged

156 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
min_to_max 1.0 aggregates and functions for PostgreSQL Server FUNC C 1
pg_calcpi 1.0 Computes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm. FUNC SQL 1
pg_json_diff 1.0 JSONB diff, JSON Patch, and merge-patch functions for PostgreSQL FUNC MIT C++ 12–18 1
pg_open_meteo 0.0.0 Prototype Rust/pgrx PostgreSQL extension associated with Open-Meteo weather data. FUNC Rust 12–17 1
pg_ortools 0.2.0 Constraint optimization extension using the HiGHS MIP/LP solver from PostgreSQL, with optional async execution. FUNC Matroid Rust 14–18 1
pg_py_ext 1.0.0 A PostgreSQL extension using PL/Python3U to add numbers FUNC PostgreSQL SQL 1
pg_rand_ext 1.0 Functions that generate random values for PostgreSQL FUNC PostgreSQL C 1
pg_snowid 3.1.0 Generate thread-safe, time-sorted Snowflake-like IDs in PostgreSQL FUNC MIT Rust 18 1
pg_variant_functions 1.0 Variant summary and allele-frequency functions over TINYINT[] genotype arrays FUNC PostgreSQL C 10–18 1
pgx_uuidv7 0.1.7 A PostgreSQL extension to generate and cast v7 UUIDs FUNC MIT Rust 17–18 1
random 2.0.0 random data generator FUNC PostgreSQL C 14–18 1
recommend 1.0 Experimental C extension providing scalar distance, text similarity, and one-dimensional array similarity functions derived from smlar. FUNC C 1
rotate_array 1.0 aggregates and functions for PostgreSQL Server FUNC C 1
split_composite 1.0 aggregates and functions for PostgreSQL Server FUNC C 1
stringtheory 1.0.2 C++ extension providing SIMD-optimized exact equality and substring-search functions for PostgreSQL text values. FUNC PostgreSQL C++ 14–16 1
sum_array 0.0.1 C function that sums PostgreSQL integer and floating-point arrays into float8. FUNC C 1
weighted_stats 1.0.0 Weighted aggregate functions FUNC PostgreSQL C 1
xata_id_extension 0.0.0 Generate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix. FUNC MIT Rust 1
I4R_AUDB_extension 1.1 AUDB operations for PostgreSQL int4range values. FUNC C
auto_counters 1.0 PostgreSQL extension for automatic contextual numbering FUNC PostgreSQL C
autoinc 1.0 functions for autoincrementing fields FUNC PostgreSQL C 14–18
bgvalidators 1.0 Validation functions for IBAN, Bulgarian EGN personal IDs, BULSTAT VAT numbers, and LNCh foreigner IDs. FUNC PostgreSQL SQL
btree_gin 1.3 support for indexing common datatypes in GIN FUNC PostgreSQL C 14–18
btree_gist 1.7 support for indexing common datatypes in GiST FUNC PostgreSQL C 14–18
countnulls 1.0.0 Simple function to count the number of NULL arguments FUNC PostgreSQL C
dbstats 1.1 Descriptive statistics and data quality analysis for PostgreSQL FUNC SQL
dict_int 1.0 text search dictionary template for integers FUNC PostgreSQL C 14–18
dict_xsyn 1.0 text search dictionary template for extended synonym processing FUNC PostgreSQL C 14–18
first_last 0.1.1 Aggregate functions to return first or last "n" elements in a group FUNC PostgreSQL SQL
generate_up_down_series 0.0.1 PostgreSQL Up Down Sequence FUNC C
get_sum 0.0.1 simple sum of two integers for postgres externsion using c FUNC C
insert_username 1.0 functions for tracking who changed a table FUNC PostgreSQL C 14–18
intagg 1.1 integer aggregator and enumerator (obsolete) FUNC PostgreSQL C 14–18
intarray 1.5 functions, operators, and index support for 1-D arrays of integers FUNC PostgreSQL C 14–18
moddatetime 1.0 functions for tracking last modification time FUNC PostgreSQL C 14–18
nfiesta_sdesign 1.1.17 PostgreSQL extension for manipulating sampling design data. FUNC EUPL-1.2 SQL 16
omnisketch 1.0.2 data structure for on-line agg of data into approximate sketch FUNC PostgreSQL C 14–18
pg_cext 1.0.0 A PostgreSQL extension to add two numbers FUNC PostgreSQL C
pg_jsonpatch 1.0.0 PostgreSQL implementation of JSON Patch FUNC MIT SQL
pg_kalman 0.1 A Kalman filter extension for PostgreSQL. FUNC C
pg_plpgsql_ext 1.0.0 A PostgreSQL extension with a PL/pgSQL function to subtract numbers FUNC PostgreSQL SQL
pg_running_stats 1.0 Mergeable Running Statistics (Welford/Chan) Extension for PostgreSQL FUNC MIT C
pg_snowflake_id 0.0.1 Snowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx FUNC MIT Rust 13–17
pgcuid2 0.1.0 Generate CUID2 text identifiers inside PostgreSQL using the cuid2 Rust crate. FUNC MIT Rust 11–16
pgrand 0.1.0 Generates random test data through a PostgreSQL FDW, with an experimental table access method. FUNC Rust 15–16
pgrx_jsonb 0.0.0 Proof-of-concept pgrx functions for iterating PostgreSQL JSONB internals and reconstructing JSON values FUNC MIT Rust 11–16
pksuid 0.1.0 generate prefixed, sortable KSUID identifiers in PostgreSQL FUNC MIT Rust 11–16
range_type_functions 0.0.4 Functions for enhancing range type functionality. FUNC PostgreSQL SQL
refint 1.0 functions for implementing referential integrity (obsolete) FUNC PostgreSQL C 14–18
session_hash_tools 1.0.0 Functions to store nested hashes in PL/Perl shared hash FUNC PostgreSQL SQL