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.

pgx_ulid · ulid type and methods · 0.2.3 · Functions and aggregates · MIT · Rust · Packagedpg_uuidv7 · Create UUIDv7 values in postgres · 1.7.0 · Functions and aggregates · MPL-2.0 · C · Packagedpg_idkit · multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) · 0.4.0 · Functions and aggregates · Apache-2.0 · Rust · Packageddb_assist · Minimal pgrx training extension exposing a hello_db_assist function. · 0.0.0 · Functions and aggregates · Unknown · Rust · Not packagedpg_hashids · Short unique id generator for PostgreSQL, using hashids · 1.3 · Functions and aggregates · MIT · C · Packagedsequential_uuids · generator of sequential UUIDs · 1.0.3 · Functions and aggregates · MIT · C · Packagedtopn · type for top-n JSONB · 2.7.1 · Functions and aggregates · AGPL-3.0 · C · Packagedpg_blkchain · C extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. · 0.0.1 · Functions and aggregates · MIT · C · Not packagedtagext · Tag Programming Example Extension · 1.0 · Functions and aggregates · MIT · Shell · Not packagedtuid · tuid datatype · 0.3.0 · 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 packagedtdigest · Provides tdigest aggregate function. · 1.4.6 · Functions and aggregates · Apache-2.0 · C · 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 · Packagedcount_distinct · An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate · 3.0.2 · Functions and aggregates · BSD-2-Clause · 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 packagedaggs_for_arrays · Various functions for computing statistics on arrays of numbers · 1.3.3 · Functions and aggregates · MIT · C · Packagedpermuteseq · Pseudo-randomly permute sequences with a format-preserving encryption on elements · 1.2.2 · Functions and aggregates · PostgreSQL · C · Packagedquantile · Quantile aggregation function · 1.1.8 · Functions and aggregates · BSD-2-Clause · C · Packagedaggs_for_vecs · Aggregate functions for array inputs · 1.4.1 · Functions and aggregates · MIT · C · Packagedxataid_extension · Generate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix. · 0.0.0 · Functions and aggregates · MPL-2.0 · Rust · Not packagedpgflake · Extension for fdw memory · 0.0.1 · Functions and aggregates · Apache-2.0 · C · Not packagedrandom_bytea · scrap code and various bug test cases for linking from bugtrackers · 1.0 · Functions and aggregates · Unknown · C · Not packagedvasco · discover hidden correlations in your data with MIC · 0.1.0 · Functions and aggregates · GPL-3.0 · C · 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 packagedpg_csv · Flexible CSV processing for Postgres · 1.0.2 · Functions and aggregates · MIT · C · Packagedfinancial · Financial aggregate functions · 1.0.1 · Functions and aggregates · PostgreSQL · C · Packagedtypeid · Allows to use TypeIDs in Postgres natively · 0.3.0 · Functions and aggregates · MIT · Rust · Packagedargm · argmax, argmin, and anyold aggregate functions · 1.1.1 · Functions and aggregates · PostgreSQL · C · Packagedjsonb_deep_sum · Recursively sum numeric fields in JSONB objects · 0.0.2 · Functions and aggregates · MIT · C · Not 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 packagedadaptive_counter · Aggregation functions and data type for distinct estimation based on adaptive sampling. · 1.3.3 · 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 packagedhyperloglog_counter · Aggregation functions and data type for distinct estimation based on HyperLogLog. · 1.2.6 · Functions and aggregates · BSD-2-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 packagedpcsa_counter · Aggregation functions and data type for distinct estimation based on PCSA. · 1.3.3 · Functions and aggregates · BSD-2-Clause · C · Not packagedpg_slug_gen · Generate cryptographically secure timestamp-based slugs · 1.0.0 · Functions and aggregates · MIT · C · Packagedprobabilistic_counter · A C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm. · 1.3.3 · Functions and aggregates · BSD-2-Clause · C · Not packagedsuperloglog_counter · C data type, functions, and aggregates for approximate distinct counting with the SuperLogLog algorithm. · 1.2.3 · Functions and aggregates · BSD-3-Clause · C · Not packagedarraymath · Array math and operators that work element by element on the contents of arrays · 1.1 · Functions and aggregates · MIT · C · Packagedbase36 · Integer Base36 types · 1.0.0 · Functions and aggregates · MIT · C · Packagedfloatvec · Math for vectors (arrays) of numbers · 1.1.1 · Functions and aggregates · MIT · C · Packagedacoustid · PostgreSQL extension for working with AcoustID fingerprints · 1.0 · Functions and aggregates · Unknown · C · Not packagedpg_uuid_next · Implementation of UUID v7 and v8 IETF drafts · 1.0 · Functions and aggregates · Unknown · C · Not packagedpg_natural_sort_order · Natural sort ordering support through a C normalization function usable with indexes. · 1.0.1 · Functions and aggregates · MIT · 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 packagedtrimmed_aggregates · C aggregate functions that discard configurable low/high outliers before computing averages, variances, and standard deviations. · 2.0.0-dev · Functions and aggregates · BSD-2-Clause · C · Not packagedpg_bitcount · Bit-count scalar and aggregate functions for integers and bit strings. · 0.0.3 · Functions and aggregates · MIT · C · Not packagedpg_rowalesce · rowalesce() is like coalesce(), but for rows and other composite types. · 0.1.12 · Functions and aggregates · PostgreSQL · SQL · Not packagedunique_id · Time-based K-sorted unique identifier generators inspired by Instagram and Sonyflake designs. · 1.0 · Functions and aggregates · BSD-3-Clause · C · Not packagedyeti · helper functions for YETI project · 1.14.1 · Functions and aggregates · Unknown · C · Not packagedcms_topn · Count-min sketch data type and aggregates for approximate frequency and top-N queries · 1.0.0 · Functions and aggregates · Unknown · C · Not packagedpopcount · provide population-count functions for PostgreSQL bit(n) values · 1.0.0 · Functions and aggregates · MIT · C · Not packagedarray_textsort · C functions for sorting and de-duplicating one-dimensional text arrays. · 1.1 · Functions and aggregates · BSD-4-Clause · C · Not packagedformat_x · Polymorphic variadic string formatting with named lookups into composite, JSONB, and HSTORE values. · 0.0.1 · 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 packagedxicor · XI Correlation Coefficient in Postgres · 0.1.1 · Functions and aggregates · GPL-3.0 · C · Packagedbinvec · C helper for summing integer bit values into arrays · 0.1 · Functions and aggregates · Unknown · C · Not packagedcalculate_markup · C function that calculates a price markup percentage by linear interpolation over a numeric price/markup array. · 1.0 · Functions and aggregates · Unknown · 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 packagedjsonb_extend · Merge two or more jsonb values · 1.0 · 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 packagedpg_uuid · generator of new UUID versions · 1.0.0 · Functions and aggregates · MIT · C · 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 · Packagedconvert · conversion functions for spatial, routing and other specialized uses · 0.1.0 · Functions and aggregates · MIT · Rust · Packagedmerge_ips · Functions to merge IP addresses, ignoring gaps · 1.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedmoss_uuidgen · Generates UUIDs for moss. We use this because there was no UUID type when moss was written, and I do not want to rewrite moss to use pgsql's uuid type · 1.0 · Functions and aggregates · GPL-3.0 · C++ · 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_libnumbertext · Converts numbers to words in multiple languages through libnumbertext. · 0.1.0 · Functions and aggregates · BSD-3-Clause · C++ · Not packagedpg_linearAlgebra · A linear algebra extension · 1.0 · Functions and aggregates · Unknown · Rust · 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 · Packagedfakeset · postgres extension to generate fake sentences · 1.0 · Functions and aggregates · Unknown · Rust · Not 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 packagedgodel_logic · Provides operators to evaluate fuzzy logic expressions according to Gödel logic. · 1.1.0 · Functions and aggregates · BSD-3-Clause · SQL · 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 packagedlukasiewicz_logic · Provides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic. · 1.1.0 · Functions and aggregates · BSD-3-Clause · SQL · 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_etag · Fast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates. · 1.0 · Functions and aggregates · BSD-3-Clause · C · Not 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 packagedpghll · Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters. · 1.0 · Functions and aggregates · MIT · 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 packagedpgstrtranslate · Adds multi-character string replacement and text-array element removal functions. · 1.0 · Functions and aggregates · Unknown · C · Not packagedproduct_logic · Provides operators to evaluate fuzzy logic expressions according to product logic. · 1.1.0 · Functions and aggregates · BSD-3-Clause · SQL · Not packagedproven · proven: PostgreSQL C bindings for formally verified safety functions from libproven · 0.5.0 · Functions and aggregates · MPL-2.0 · C · Not packagedsafecast · Pure-SQL helper functions that return NULL for some invalid text-to-number casts. · 0.0.1 · Functions and aggregates · Apache-2.0 · SQL · Not packagedsrf · Minimal C example implementing an inclusive integer set-returning function. · 1.0 · Functions and aggregates · Unknown · C · Not packagedtranslate_isbn · C function that converts text ISBN codes between ISBN-10 and ISBN-13 forms for Evergreen-compatible search expansion. · 1.0 · Functions and aggregates · Unknown · C · Not packagedvalidadores · Brazilian CPF check-digit validator, operator, and domain · 0.0.2 · Functions and aggregates · PostgreSQL · SQL · Not packagedwrapper_deltalake · Unfinished pgrx hello-world prototype originally planned as a Delta Lake foreign data wrapper. · 0.0.0 · Functions and aggregates · Apache-2.0 · Rust · 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 packagedbigintarray · Postgres extension like intarray, but for bigints · 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 packagedcount_nulls · Count the number of null arguments · 0.9.6 · Functions and aggregates · BSD-2-Clause · SQL · 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 packagedgraph_component · Compute graph components · 1.0.0 · Functions and aggregates · MIT · C · Not packagedhello_world · A simple hello-world Postgres extension using sql/plpgsql implementing a russian roulette function. · 1.0 · Functions and aggregates · Unknown · SQL · 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 packagedjsonb_delete · hstore-style delete function and operator for jsonb · 1.0 · Functions and aggregates · Unknown · C · Not packagedjsonb_extra · Extra JSONB functions · 1.0 · Functions and aggregates · Unknown · C · Not packagedjsonb_opx · hstore-style functions and operators for jsonb · 1.0 · Functions and aggregates · Unknown · C · Not packagedjsonfun · Extract JSON values by variadic dot-delimited key paths · 0.1 · 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 packagedmedian · Median aggregate function for input sets · 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_algorithms · C extension that adds example algorithm functions, including bubble sort and quicksort for integer arrays. · 1.0 · Functions and aggregates · MIT · 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_random_string · Generates an alphanumeric string of a requested length with a C function. · 0.0.1 · Functions and aggregates · Unknown · C · Not packagedpg_sequence · ERP document numbering with formatted, scoped, auto-incrementing sequences · 0.2.0 · Functions and aggregates · Unknown · Rust · Not packagedpg_snowid · Generate thread-safe, time-sorted Snowflake-like IDs in PostgreSQL · 3.1.0 · Functions and aggregates · MIT · Rust · Not packagedpg_statkit · Descriptive statistics and clinical effect-size functions over arrays. · 1.1.0 · Functions and aggregates · MIT · Rust · Not packagedpg_string_extension · C string helpers for palindrome checks, anagram checks, and character sorting. · 0.1 · Functions and aggregates · Unknown · C · Not packagedpg_variant_functions · Variant summary and allele-frequency functions over TINYINT[] genotype arrays · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedpgorpy · OR-tools python accessible from the database · 0.0.0 · Functions and aggregates · GPL-2.0 · SQL · 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 packagedrpg · R-inspired PL/pgSQL data manipulation functions. · 0.1 · Functions and aggregates · Unknown · SQL · 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 packagedtm_postgres_basics · PL/pgSQL helper functions for resolving relation OIDs and traversing table inheritance. · 1.0.0 · Functions and aggregates · MIT · SQL · Not packagedunits · Unit conversion table and PL/pgSQL conversion function for length units. · 0.0.1 · Functions and aggregates · Unknown · SQL · 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 packagedaggs · Testing aggregation functions · 0.1 · Functions and aggregates · Apache-2.0 · C · Not packagedalohadb_approx · Approximate query processing: HLL, Count-Min Sketch, Top-K · 1.1 · Functions and aggregates · MIT · 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 packagedbobbie@hello · An extension to generate greetings · 0.0.1 · Functions and aggregates · Unknown · 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 · Packagedcapitalize · A function to capitalize all the given character · 1.0 · Functions and aggregates · Unknown · C · Not packagedcem-uuidv7 · UUIDv7 extension · 1.0.2 · Functions and aggregates · Unknown · SQL · Not packagedcheck_digits · Functions to check various identification numbers · 0.3.3 · Functions and aggregates · MIT · C · Not 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 packageddev@tienlen_validation · Tien Len validation functions for game server · 0.1.0 · 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 · Packagedexploring_aggregates · pgrx example defining a custom integer-sum aggregate with serialized state. · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedfbsql · Closure-preserving formula-based statistical modeling in SQL · 0.1.0 · Functions and aggregates · MIT · SQL · Packagedfft_approximate · FFT-based approximate aggregate range queries over time-series data. · 1.0 · Functions and aggregates · MIT · C · Not packagedfirst_last · Aggregate functions to return first or last "n" elements in a group · 0.1.1 · Functions and aggregates · PostgreSQL · SQL · Not packagedfrkn_avg · C aggregate extension providing my_avg for bigint and floating-point inputs. · 0.0.1 · Functions and aggregates · Unknown · C · Not packagedgcd · C function that computes the greatest common divisor of an integer array. · 0.0.1 · Functions and aggregates · Unknown · C · 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 packagedhello_pg · Minimal pgrx hello-world extension used to reproduce a macOS build issue. · 0.0.0 · Functions and aggregates · Unknown · Rust · Not packagedhelloworldtable · pgrx example returning a one-row table containing a Hello World greeting. · 0.0.0 · Functions and aggregates · Unknown · Rust · 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 · Packagedjsonb_delete_array · Delete jsonb keys or string elements listed in a text array · 1.0 · Functions and aggregates · Unknown · C · Not packagedjsonb_explorer · Inspect jsonb trees and paths · 1.0 · Functions and aggregates · Unknown · C · Not packagedkiwicopple-is_even · Calculates if a value is even. · 0.0.1 · Functions and aggregates · Unknown · SQL · Not packagedlaunchql-stamps · 🛠. basic pg utils · 0.4.5 · Functions and aggregates · MIT · C · Not packagedlower_quantile · Lower quantile aggregate function · 1.0.3 · Functions and aggregates · BSD-2-Clause · C · Packagedmanip · Various manipulation functions · 0.1 · Functions and aggregates · Apache-2.0 · C · Not packagedmemvol · Memory units · 1.0 · Functions and aggregates · Unknown · C · Not packagedmoddatetime · functions for tracking last modification time · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedmtm · aggregate to find min and max · 0.1 · Functions and aggregates · Unknown · SQL · Not 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 · Packagedpbloompg · portable bloom filter, create, serialize, query across Go, Rust, Postgres · 0.0.0 · Functions and aggregates · MIT · Rust · Not packagedpg_cext · A PostgreSQL extension to add two numbers · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packagedpg_climb · Rock-climbing grade conversion and utility functions. · 1.0 · Functions and aggregates · Unknown · C · Not packagedpg_elephant · Toy example extension exposing a pg_elephant() function that returns ASCII elephant text. · 1.0 · Functions and aggregates · Unknown · C · Not packagedpg_gen_uid · Adds a PL/pgSQL function that generates random lowercase alphanumeric identifiers using pgcrypto. · 0.0.1 · Functions and aggregates · Unknown · SQL · Not packagedpg_jewelry_tools · An extension for PSQL with useful functionality for jewelry companies. So far, this is a project created for educational purposes. · 0.0.1 · Functions and aggregates · Unknown · 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_luhn · Luhn checksum, validation, and check-digit generation functions. · 0.0.0 · Functions and aggregates · Unknown · Rust · Not packagedpg_meritrank · The extension provides functionality for computing and ranking a merit in a Postgres database. · 0.0.1 · Functions and aggregates · MIT · Rust · Not packagedpg_num2int_direct_comp · Exact numeric/float-to-integer comparison operators that preserve index use. · 1.0.0 · Functions and aggregates · MIT · C · Not packagedpg_pagination · Rust functions for cursor- and offset-based pagination with JSON results. · 0.1.0 · Functions and aggregates · Unknown · Rust · 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_row_hashes · Computes deterministic row fingerprints, checksums, and XOR aggregates with SeaHash and FarmHash variants. · 0.3.2 · Functions and aggregates · Unknown · Rust · Not packagedpg_running_stats · Mergeable Running Statistics (Welford/Chan) Extension for PostgreSQL · 1.0 · Functions and aggregates · MIT · C · Not packagedpg_slugify · Normalize text into URL-friendly slugs with unaccent · 0.0.1 · Functions and aggregates · Unknown · SQL · 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 packagedpgmcisid · MCIS ID V1 generator · 1.0 · Functions and aggregates · Unknown · C · 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 packagedphilihp@pg_openskill · OpenSkill Plackett-Luce ratings as a database.dev TLE package. · 0.1.0 · Functions and aggregates · MIT · SQL · Not packagedpksuid · generate prefixed, sortable KSUID identifiers in PostgreSQL · 0.1.0 · Functions and aggregates · MIT · Rust · Not packagedpyramid_generate · Generate uniformly distributed random float8 vectors by dimension and size · 1.0 · Functions and aggregates · Unknown · C · Not packagedrandomstring · randomstring: generate pseudo-random text and bytea values · 1.0.0 · Functions and aggregates · Unknown · C · Not packagedrange_tools · Tools for use with range types · 0.1.2 · Functions and aggregates · MIT · SQL · 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 · Packagedreplace_string · Rust/pgrx function for literal string replacement · 0.0.0 · Functions and aggregates · Unknown · Rust · Not packagedsession_hash_tools · Functions to store nested hashes in PL/Perl shared hash · 1.0.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedspqrhash · Murmur3 and City hash functions for PG · 1.2 · Functions and aggregates · Unknown · C · Not packagedtalib_ext · postgres extension to do technical analysis on postgres · 1.0 · Functions and aggregates · Unknown · Rust · Not packagedtcn · Triggered change notifications · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedtext_funcs · Tutorial 3 text functions · 1.0 · Functions and aggregates · Unknown · C · Not 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 · Packagedutils · Minimal C extension example providing integer addition and multiplication functions. · 0.0.1 · Functions and aggregates · MIT · C · Not 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 packagedvectoragg · Float-array range sum, clamp, and decimation functions · 1.0 · Functions and aggregates · Unknown · C · Not packagedverhoeff · Implement a Postgres Extension for Verhoeff Algorithm · 1.0 · Functions and aggregates · Unknown · C · Not packagedworld · pgrx tutorial functions for multilingual hello-world greetings. · 0.0.0 · Functions and aggregates · Unknown · Rust · Not packaged

277 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
composite 1.0 aggregates and functions for PostgreSQL Server FUNC C 1
count_char 1.0 aggregates and functions for PostgreSQL Server FUNC C 1
count_nulls 0.9.6 Count the number of null arguments FUNC BSD-2-Clause SQL 1
fhir_jsonb 1.0 Synthetic FHIR JSONB data generator and query benchmark fixture for PostgreSQL. FUNC SQL 10–18 1
get_column 1.0.0 Fetch a column value from a record by name FUNC PostgreSQL C 1
graph_component 1.0.0 Compute graph components FUNC MIT C 1
hello_world 1.0 A simple hello-world Postgres extension using sql/plpgsql implementing a russian roulette function. FUNC SQL 1
htc 2.1 Horvitz-Thompson continuous-population estimator functions for PostgreSQL. FUNC EUPL-1.2 C 16 1
insert_array 1.0 aggregates and functions for PostgreSQL Server FUNC C 1
jsonb_delete 1.0 hstore-style delete function and operator for jsonb FUNC C 10–18 1
jsonb_extra 1.0 Extra JSONB functions FUNC C 1
jsonb_opx 1.0 hstore-style functions and operators for jsonb FUNC C 1
jsonfun 0.1 Extract JSON values by variadic dot-delimited key paths FUNC C 1
kq_fx 1.0.1 ketteQ, Inc. FUNC Apache-2.0 Rust 13–18 1
mean 1.0 aggregates and functions for PostgreSQL Server FUNC C 1
median 1.0 Median aggregate function for input sets FUNC C 10–12 1
min_to_max 1.0 aggregates and functions for PostgreSQL Server FUNC C 1
pg_algorithms 1.0 C extension that adds example algorithm functions, including bubble sort and quicksort for integer arrays. FUNC MIT 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_random_string 0.0.1 Generates an alphanumeric string of a requested length with a C function. FUNC C 1
pg_sequence 0.2.0 ERP document numbering with formatted, scoped, auto-incrementing sequences FUNC Rust 1
pg_snowid 3.1.0 Generate thread-safe, time-sorted Snowflake-like IDs in PostgreSQL FUNC MIT Rust 18 1
pg_statkit 1.1.0 Descriptive statistics and clinical effect-size functions over arrays. FUNC MIT Rust 13–17 1
pg_string_extension 0.1 C string helpers for palindrome checks, anagram checks, and character sorting. FUNC C 1
pg_variant_functions 1.0 Variant summary and allele-frequency functions over TINYINT[] genotype arrays FUNC PostgreSQL C 10–18 1
pgorpy 0.0.0 OR-tools python accessible from the database FUNC GPL-2.0 SQL 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
rpg 0.1 R-inspired PL/pgSQL data manipulation functions. FUNC SQL 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
tm_postgres_basics 1.0.0 PL/pgSQL helper functions for resolving relation OIDs and traversing table inheritance. FUNC MIT SQL 1
units 0.0.1 Unit conversion table and PL/pgSQL conversion function for length units. FUNC SQL 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
aggs 0.1 Testing aggregation functions FUNC Apache-2.0 C
alohadb_approx 1.1 Approximate query processing: HLL, Count-Min Sketch, Top-K FUNC MIT 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
bobbie@hello 0.0.1 An extension to generate greetings FUNC SQL