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 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 packagedcidr · Transform an IPv4 or IPv6 address range into the minimal set of CIDR blocks · 1.0 · Functions and aggregates · MIT · SQL · Not packagedmerge_ips · Functions to merge IP addresses, ignoring gaps · 1.0 · Functions and aggregates · PostgreSQL · SQL · Not packagednfiesta · PostgreSQL extension implementing nFIESTA forest inventory estimation functionality. · 5.0.0 · Functions and aggregates · EUPL-1.2 · SQL · Not packagedpg_normalize_email · Normalize email addresses in PostgreSQL · 1.0.9 · Functions and aggregates · PostgreSQL · SQL · Not 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 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 packagedlukasiewicz_logic · Provides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic. · 1.1.0 · Functions and aggregates · BSD-3-Clause · SQL · Not packagedpg_sample_ext · A Sample PostgreSQL extension · 1.0.2 · Functions and aggregates · PostgreSQL · SQL · 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 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 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 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 packagedhello_world · A simple hello-world Postgres extension using sql/plpgsql implementing a russian roulette function. · 1.0 · Functions and aggregates · Unknown · SQL · Not packagedpg_calcpi · Computes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm. · 1.0 · Functions and aggregates · Unknown · SQL · Not packagedpg_py_ext · A PostgreSQL extension using PL/Python3U to add numbers · 1.0.0 · Functions and aggregates · PostgreSQL · SQL · Not packagedpgorpy · OR-tools python accessible from the database · 0.0.0 · Functions and aggregates · GPL-2.0 · SQL · Not packagedrpg · R-inspired PL/pgSQL data manipulation functions. · 0.1 · Functions and aggregates · Unknown · SQL · 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 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 packagedcem-uuidv7 · UUIDv7 extension · 1.0.2 · Functions and aggregates · Unknown · SQL · 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 packagedfbsql · Closure-preserving formula-based statistical modeling in SQL · 0.1.0 · Functions and aggregates · MIT · SQL · Packagedfirst_last · Aggregate functions to return first or last "n" elements in a group · 0.1.1 · Functions and aggregates · PostgreSQL · SQL · Not packagedkiwicopple-is_even · Calculates if a value is even. · 0.0.1 · Functions and aggregates · Unknown · SQL · Not 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 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_jsonpatch · PostgreSQL implementation of JSON Patch · 1.0.0 · Functions and aggregates · MIT · SQL · 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_slugify · Normalize text into URL-friendly slugs with unaccent · 0.0.1 · Functions and aggregates · Unknown · SQL · Not packagedphilihp@pg_openskill · OpenSkill Plackett-Luce ratings as a database.dev TLE package. · 0.1.0 · Functions and aggregates · MIT · SQL · 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 packagedsession_hash_tools · Functions to store nested hashes in PL/Perl shared hash · 1.0.0 · Functions and aggregates · PostgreSQL · SQL · Not packaged

44 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
uuidv7-sql 1.1 Pure SQL and PL/pgSQL functions for generating, inspecting, and transforming UUID version 7 values. FUNC PostgreSQL SQL 100
json_query 0.9 Generate PostgreSQL WHERE clause predicates from JSONB filter objects. FUNC PostgreSQL SQL 10–18 9
pgaut 1.0.0 Auto Update Timestamp for PostgreSQL FUNC PostgreSQL SQL 10–11 9
pg_rowalesce 0.1.12 rowalesce() is like coalesce(), but for rows and other composite types. FUNC PostgreSQL SQL 8
cidr 1.0 Transform an IPv4 or IPv6 address range into the minimal set of CIDR blocks FUNC MIT SQL 4
merge_ips 1.0 Functions to merge IP addresses, ignoring gaps FUNC PostgreSQL SQL 3
nfiesta 5.0.0 PostgreSQL extension implementing nFIESTA forest inventory estimation functionality. FUNC EUPL-1.2 SQL 16 3
pg_normalize_email 1.0.9 Normalize email addresses in PostgreSQL FUNC PostgreSQL SQL 12–18 3
short_ids 0.1.0 PL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks. FUNC PostgreSQL SQL 10–18 3
godel_logic 1.1.0 Provides operators to evaluate fuzzy logic expressions according to Gödel logic. FUNC BSD-3-Clause SQL 2
json_utils 0.1 JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+. FUNC PostgreSQL SQL 10–18 2
lukasiewicz_logic 1.1.0 Provides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic. FUNC BSD-3-Clause SQL 2
pg_sample_ext 1.0.2 A Sample PostgreSQL extension FUNC PostgreSQL SQL 2
product_logic 1.1.0 Provides operators to evaluate fuzzy logic expressions according to product logic. FUNC BSD-3-Clause SQL 2
safecast 0.0.1 Pure-SQL helper functions that return NULL for some invalid text-to-number casts. FUNC Apache-2.0 SQL 2
validadores 0.0.2 Brazilian CPF check-digit validator, operator, and domain FUNC PostgreSQL SQL 2
approx_count 1.0 Fast approximate row counts for tables and indexes in PostgreSQL 14+ from pg class.reltuples, with a governed ANALYZE refresh FUNC SQL 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
hello_world 1.0 A simple hello-world Postgres extension using sql/plpgsql implementing a russian roulette function. FUNC SQL 1
pg_calcpi 1.0 Computes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm. FUNC SQL 1
pg_py_ext 1.0.0 A PostgreSQL extension using PL/Python3U to add numbers FUNC PostgreSQL SQL 1
pgorpy 0.0.0 OR-tools python accessible from the database FUNC GPL-2.0 SQL 1
rpg 0.1 R-inspired PL/pgSQL data manipulation functions. FUNC SQL 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
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
cem-uuidv7 1.0.2 UUIDv7 extension FUNC SQL
dbstats 1.1 Descriptive statistics and data quality analysis for PostgreSQL FUNC SQL
dev@tienlen_validation 0.1.0 Tien Len validation functions for game server FUNC SQL
fbsql 0.1.0 Closure-preserving formula-based statistical modeling in SQL FUNC MIT SQL 16–18
first_last 0.1.1 Aggregate functions to return first or last "n" elements in a group FUNC PostgreSQL SQL
kiwicopple-is_even 0.0.1 Calculates if a value is even. FUNC SQL
mtm 0.1 aggregate to find min and max FUNC SQL
nfiesta_sdesign 1.1.17 PostgreSQL extension for manipulating sampling design data. FUNC EUPL-1.2 SQL 16
pg_gen_uid 0.0.1 Adds a PL/pgSQL function that generates random lowercase alphanumeric identifiers using pgcrypto. FUNC SQL
pg_jsonpatch 1.0.0 PostgreSQL implementation of JSON Patch FUNC MIT SQL
pg_plpgsql_ext 1.0.0 A PostgreSQL extension with a PL/pgSQL function to subtract numbers FUNC PostgreSQL SQL
pg_slugify 0.0.1 Normalize text into URL-friendly slugs with unaccent FUNC SQL
philihp@pg_openskill 0.1.0 OpenSkill Plackett-Luce ratings as a database.dev TLE package. FUNC MIT SQL 16
range_tools 0.1.2 Tools for use with range types FUNC MIT SQL
range_type_functions 0.0.4 Functions for enhancing range type functionality. FUNC PostgreSQL SQL
session_hash_tools 1.0.0 Functions to store nested hashes in PL/Perl shared hash FUNC PostgreSQL SQL