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.

uuidv7-sql · Pure SQL and PL/pgSQL functions for generating, inspecting, and transforming UUID version 7 values. · 1.1 · Functions and aggregates · PostgreSQL · SQL · Not packagedsnowflake · Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL · 2.5.0 · Functions and aggregates · PostgreSQL · C · Packagedpermuteseq · Pseudo-randomly permute sequences with a format-preserving encryption on elements · 1.2.2 · Functions and aggregates · PostgreSQL · 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 · 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 · 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 · 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 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 packagedpsl · Returns the registrable domain for a hostname using a compiled-in Public Suffix List. · 1.0.0 · Functions and aggregates · PostgreSQL · C · Not packageduuid-freebsd · UUID generation functions for PostgreSQL on FreeBSD. · 2.0 · Functions and aggregates · PostgreSQL · C · Not packagedpg_accumulator · Accumulation registers for balance and turnover tracking in PostgreSQL · 1.1.3 · Functions and aggregates · PostgreSQL · C · Packagedkissfft · Fast-Fourier transformer (fft) · 0.0.1 · Functions and aggregates · PostgreSQL · 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 packagedmerge_ips · Functions to merge IP addresses, ignoring gaps · 1.0 · Functions and aggregates · PostgreSQL · SQL · 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_normalize_email · Normalize email addresses in PostgreSQL · 1.0.9 · Functions and aggregates · PostgreSQL · SQL · 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 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 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 packagedpg_sample_ext · A Sample PostgreSQL extension · 1.0.2 · Functions and aggregates · PostgreSQL · SQL · Not packagedvalidadores · Brazilian CPF check-digit validator, operator, and domain · 0.0.2 · Functions and aggregates · PostgreSQL · SQL · Not packagedget_column · Fetch a column value from a record by name · 1.0.0 · Functions and aggregates · PostgreSQL · C · 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_variant_functions · Variant summary and allele-frequency functions over TINYINT[] genotype arrays · 1.0 · Functions and aggregates · PostgreSQL · C · Not packagedrandom · random data generator · 2.0.0 · Functions and aggregates · PostgreSQL · C · 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 packagedweighted_stats · Weighted aggregate functions · 1.0.0 · Functions and aggregates · PostgreSQL · 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 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 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 · 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_plpgsql_ext · A PostgreSQL extension with a PL/pgSQL function to subtract numbers · 1.0.0 · Functions and aggregates · PostgreSQL · 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 · 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 · Packaged

70 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
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
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
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
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_plpgsql_ext 1.0.0 A PostgreSQL extension with a PL/pgSQL function to subtract numbers FUNC PostgreSQL SQL
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
tcn 1.0 Triggered change notifications FUNC PostgreSQL C 14–18
tsm_system_rows 1.0 TABLESAMPLE method which accepts number of rows as a limit FUNC PostgreSQL C 14–18
tsm_system_time 1.0 TABLESAMPLE method which accepts time in milliseconds as a limit FUNC PostgreSQL C 14–18
unaccent 1.1 text search dictionary that removes accents FUNC PostgreSQL C 14–18
uuid-ossp 1.1 generate universally unique identifiers (UUIDs) FUNC PostgreSQL C 14–18