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.

pglite_fusion · Embed an SQLite database in your PostgreSQL table · 0.0.6 · Data types · MIT · Rust · Packagedautomerge · CRDT support in Postgres (experimental) · 0.0.1 · Data types · PostgreSQL · C · Not packageduint · unsigned integer types · 1.20250815 · Data types · PostgreSQL · C · Packageduri · URI Data type for PostgreSQL · 1.20251029 · Data types · PostgreSQL · C · Packagedpg_rrule · RRULE field type for PostgreSQL · 0.3.0 · Data types · MIT · C · Packagedsemver · Semantic version data type · 0.41.0 · Data types · PostgreSQL · C · Packagedip4r · IPv4/v6 and IPv4/v6 range index type for PostgreSQL · 2.4.3 · Data types · PostgreSQL · C · Packagedpgcalendar · Recurring calendar, schedule, and exception management for PostgreSQL · 1.1.0 · Data types · MIT · SQL · Packagedpostpic · A PostgreSQL image type with SQL image-processing and metadata functions, backed by GraphicsMagick, plus import/export utilities. · 0.9.1 · Data types · LGPL-3.0 · C · Not packagedprefix · Prefix Range module for PostgreSQL · 1.2.11 · Data types · PostgreSQL · C · Packagedpgbson · BSON data type and accessor functions for PostgreSQL · 2.1.0 · Data types · MIT · C · Packagedemailaddr · Email address type for PostgreSQL · 0 · Data types · Unknown · C · Packagedpg_ferroid · PostgreSQL ULID type and generation functions backed by ferroid · 2.0.0 · Data types · MIT · Rust · Not packagedfixeddecimal · Fixed-precision decimal type optimized for performance and storage. · 1.1.0 · Data types · PostgreSQL · C · Not packagedpostgres_web3 · Optimized PostgreSQL types and operators for 128/256-bit signed and unsigned integers plus 160/256-bit hexadecimal web3 values. · 1.0 · Data types · MIT · C · Not packageduint128 · Native uint128 type · 1.2.0 · Data types · PostgreSQL · C · Packagedtinyint · One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. · 0.1.1 · Data types · PostgreSQL · C · Not packagedbignum · Unlimited precision integers for PostgreSQL · 0.8.0 · Data types · PostgreSQL · C · Not packagedpgbitmap · Bitmap-type extension for PostgreSQL · 0.9.5 · Data types · BSD-2-Clause · C · Not packagedcurrency · Custom PostgreSQL currency type in 1Byte · 0.0.3 · Data types · MIT · C · Packagedccnumber · data type representing encrypted CC numbers · 1.0 · Data types · Unknown · C · Not packagedvarint · A signed and unsigned 64 bit integer encoding scheme that saves disk space · 0.1.0 · Data types · PostgreSQL · C · Not packagedlibversion · Version string comparison functions and versiontext type using libversion · 2.0.0 · Data types · MIT · C · Not packagedcrockford · Crockford Base32 encoded unsigned integer data types · 0.8.34 · Data types · PostgreSQL · C · Not packagedpair · A key/value pair data type for PostgreSQL · 0.1.2 · Data types · PostgreSQL · C · Not packagediban · IBAN data type and validation functions for PostgreSQL · 1.1 · Data types · GPL-3.0 · C++ · Not packagedinetrange · Range type for PostgreSQL inet values with range operators and GiST indexing support. · 1.0.2 · Data types · MIT · C · Not packagedl10n_table_dependent_extension · PostgreSQL l10n toolbox · 0.8.3 · Data types · PostgreSQL · SQL · Packagedpg_xenophile · More than the bare necessities for PostgreSQL i18n and l10n. · 0.8.3 · Data types · PostgreSQL · SQL · Packagedcas_codes · CAS Registry Number data type and validation support for PostgreSQL. · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagedelements · Chemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx. · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagediso_codes · ISO country code enum/data types for PostgreSQL, generated with pgrx. · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagedmedia_types · Strongly typed MIME media-type data type for PostgreSQL · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagedmolecular_formulas · Molecular-formula parser and strongly typed PostgreSQL data type · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagedpg_thrift · Encode, decode, and query Apache Thrift binary and compact protocol values in PostgreSQL. · 1.0 · Data types · Unknown · C · Not packagedpgsql_rrule · Pure SQL PostgreSQL data types and functions for parsing and expanding RFC 5545 recurrence rules. · 0.0.4 · Data types · PostgreSQL · SQL · Not packagedcountry · Country data type, ISO 3166-1 · 0.0.3 · Data types · PostgreSQL · C · Packageddatalink · SQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL · 0.5.0 · Data types · PostgreSQL · C · Not packagedplid · A 128-bit, lexicographically sortable PostgreSQL PLID type with short prefixes, millisecond timestamps, randomness, and optional monotonic generation. · 0.0.0 · Data types · MIT · Rust · Not packagedtelephone · PostgreSQL data type for normalized telephone numbers with dialing-plan validation. · 0.0.1 · Data types · PostgreSQL · C · Not packagedcbor · Concise Binary Object Representation data type for PostgreSQL. · 0.1.0 · Data types · PostgreSQL · C · Not packagedhashtypes · sha1, md5 and other data types for PostgreSQL · 0.1.5 · Data types · PostgreSQL · C · Packagedpg_text_semver · Semantic version domain and comparison operators for PostgreSQL · 1.2.1 · Data types · PostgreSQL · SQL · Packagedpostbis · Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions. · 1.0 · Data types · PostgreSQL · C · Packageduints · C extension providing unsigned 16-bit and 32-bit integer types with casts, operators, and numeric support functions. · 0.9 · Data types · PostgreSQL · C · Not packagedajbool · Three-valued boolean type with a pseudo-NULL unknown state for primary keys. · 0.0.3 · Data types · PostgreSQL · C · Not packagedemail · Email address data type with validation, equality operators, and user/domain helper functions. · 0.1 · Data types · PostgreSQL · C · Not packagedpg_semver · Version(SEMVER) data type for postgresql · 0.0.1 · Data types · MIT · C · Not packagedjsonb_schema · jsonb with separately stored schema · 1.0 · Data types · PostgreSQL · C · Not packagedvariant · Variant data type that can store values from other PostgreSQL types. · 1.0.1 · Data types · BSD-2-Clause · C · Not packageddevice_type · Fixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes. · 0.0.2 · Data types · PostgreSQL · C · Not packagedlpathtree · Hierarchical path types using slash-separated labels · 1.0 · Data types · Unknown · C · Not packagednumber · Variable-width integer data type for PostgreSQL · 1 · Data types · MIT · C · Not packagedpgsfti · PostgreSQL data type for simple trapezoidal fuzzy time intervals and fuzzy temporal relations. · 1.0 · Data types · MIT · C · Not packagedpg_chainutils · Blockchain utility types and functions for PostgreSQL, built with pgrx. · 0.2.4 · Data types · MIT · Rust · Not packagedpg_color · Color data type for PostgreSQL · 1.1 · Data types · Apache-2.0 · C · Not packagedpg_erlang_term · PostgreSQL type for encoding, storing, and decoding Erlang External Term Format values. · 0.0.1 · Data types · PostgreSQL · C · Not packagedsalesforce_id · Compact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs. · 1.0 · Data types · PostgreSQL · C · Not packagedstudent · Let's learn how to add types in PostgreSQL 👨🏻‍💻 · 1.0 · Data types · Unknown · C · Not packagedxnode · Implementation of XML using DOM. · 0.7.2 · Data types · PostgreSQL · C · Not packagedbase32_4b · Base32 data type stored in four bytes with comparison operators. · 0.0.1 · Data types · PostgreSQL · C · Not packagedcert · PostgreSQL data types and functions for X.509 certificates, certificate requests, and related OpenSSL objects. · 0.1.1 · Data types · PostgreSQL · C · Not packagedchkpass · data type for auto-encrypted passwords · 1.0 · Data types · PostgreSQL · C · Packagedcomplex · Complex-number data type for PostgreSQL. · 1.0 · Data types · Unknown · C · Not packagedhashset · Provides hashset type. · 0.0.1 · Data types · PostgreSQL · C · Not packagedlanguage · Custom PostgreSQL language enumeration type · 0.0.4 · Data types · PostgreSQL · C · Not packagednumeric_domains · Custom numeric domains for PostgreSQL · 1.0 · Data types · MIT · SQL · Not packagedpassword · PostgreSQL data type for passwords · 0.0.1 · Data types · PostgreSQL · C · Not packagedpg_genotype · Provides a compact one-byte genotype type that preserves allele order and supports insertion and deletion symbols. · 1.0 · Data types · PostgreSQL · C · Not packagedpg_imputed_genotype · Store imputed-genotype probability triples in a packed four-byte PostgreSQL type. · 1.0 · Data types · PostgreSQL · C · Not packagedpg_sexp_rs · PostgreSQL extension to add support for s-expressions store, query, index. · 0.1.0 · Data types · Apache-2.0 · Rust · Not packagedpgpm-types · PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. · 0.15.5 · Data types · MIT · C · Not packagedpguri · provide indexable URI and domain-name types and URI text search · 1.0 · Data types · PostgreSQL · C · Not packagedvpack · VelocyPack data type, path type, operators, casts, and JSON/BSON conversion support for PostgreSQL. · 0.1 · Data types · Unknown · C++ · Not packagedajversion · Semantic version type for PostgreSQL backed by compact integer storage. · 0.0.1 · Data types · PostgreSQL · C · Not packagedboolean_cascaded · Composite boolean status type with operators and trigger helper for cascaded parent-child status. · 2.0 · Data types · PostgreSQL · SQL · Not packageddebversion · Debian version number data type · 1.2.0 · Data types · PostgreSQL · SQL · Packageddecimal · Decimal32 and decimal64 decimal floating-point data types with arithmetic and casts · 1.0 · Data types · PostgreSQL · C · Not packagedeigen · New array types and linear-algebra functions based on the Eigen numerical template library. · 1.1 · Data types · MIT · C++ · Not packagedevr · PostgreSQL extension for RPM epoch/version/release datatype parsing. · 0.0.2 · Data types · GPL-3.0 · SQL · Not packagedhamradio · ham radio extension · 1 · Data types · PostgreSQL · SQL · Not packagedknx · data types for KNX Addresses · 1.0 · Data types · BSD-3-Clause · C · Not packagedpg_digest · Data type for efficient storage of hash digests in PostgreSQL. · 1.0 · Data types · GPL-3.0 · C · Not packagedpg_msgpack · MessagePack data type with JSON and bytea casts and access operators · 0.0.1 · Data types · PostgreSQL · C · Not packagedpg_nanp · Validated and consistently formatted North American Numbering Plan data type · 1.0 · Data types · PostgreSQL · C · Not packagedpg_postal_code_ca · an efficient, validated, formatted Canadian postal code type · 1.0 · Data types · PostgreSQL · C · Not packagedpg_prob · Probabilistic data types for PostgreSQL - Monte Carlo simulation in SQL · 0.2.0 · Data types · Matroid · Rust · Not packagedpg_vartype · Multiple scalar types in a single column · 0.4 · Data types · Unknown · C · Not packagedpg_year · YEAR data type · 0.0.1 · Data types · Unknown · C · Not packagedpgopenssltypes · PostgreSQL extension that stores and manipulates OpenSSL cryptographic types and functionality. · 0.0.1 · Data types · PostgreSQL · C · Not packagedrrule_safe · Memory-safe iCalendar recurrence-rule evaluation for PostgreSQL. · 0.2.1 · Data types · PostgreSQL · Rust · Not packagedruid · Compact 22-character Base64 representation of PostgreSQL UUID values. · 0.0.4 · Data types · Unknown · C · Not packagedsaturated_int · Integer data type with saturation arithmetic that clamps overflow to int4 bounds. · 0.0.1 · Data types · MIT · C · Not packagedspan · C data type for indexed document text spans, with casts, comparisons, B-tree/hash operator classes, aggregates, and accessors. · 0.1.0 · Data types · PostgreSQL · C · Not packagedtext_domains · Pure-SQL collection of constrained PostgreSQL text domains for nonempty, alphabetic, alphanumeric, case-specific, and fixed-length values. · 1.0 · Data types · MIT · SQL · Not packageduniqueidentifier · Legacy 16-byte uniqueidentifier data type, comparison operators, casts, and newid() generation for PostgreSQL. · 1.0 · Data types · LGPL-2.1 · C · Not packagedcas · CAS Registry Number data type for PostgreSQL. · 0.1.0 · Data types · Unknown · C · Not packagedchess · SAN and FEN chess notation data types and functions for PostgreSQL · 1.0 · Data types · Unknown · C · Not packagedchess_index · Data types for indexing chess positions. · 0.0.1 · Data types · MIT · C · Not packagedcitext · data type for case-insensitive character strings · 1.6 · Data types · PostgreSQL · C · Packagedconda_pgsql_rust_ext · Conda version data type and helpers for PostgreSQL, implemented with pgrx and rattler_conda_types. · 0.0.0 · Data types · MIT · Rust · Not packagedcondaversion · Conda package version number data type implemented as a C++ PostgreSQL extension. · 1.0 · Data types · MIT · C++ · Not packagedcranges · Closed forms of PostgreSQL discrete built-in ranges · 1.0.0 · Data types · Unknown · C · Not packagedcube · data type for multidimensional cubes · 1.5 · Data types · PostgreSQL · C · Packagedgsscode · Compact indexed type for UK ONS and GSS geography codes · 1.1.1 · Data types · PostgreSQL · C · Not packagedgsscode_ons_refresh · Optional in-database refresh for the gsscode geography-type registry · 1.0.0 · Data types · PostgreSQL · PLpgSQL · Not packagedhstore · data type for storing sets of (key, value) pairs · 1.8 · Data types · PostgreSQL · C · Packagedisn · data types for international product numbering standards · 1.2 · Data types · PostgreSQL · C · Packagedltree · data type for hierarchical tree-like structures · 1.3 · Data types · PostgreSQL · C · Packagedos_name · Enumerable mobile os type, stored in a single-byte, fixed-length type. · 0.0.3 · Data types · PostgreSQL · SQL · Not packagedpg_address · Extension creates composite type to store address · 0.0.3 · Data types · Unknown · SQL · Not packagedpg_bikram_sambat · Bikram Sambat date type and AD/BS conversion functions · 0.1.0 · Data types · PostgreSQL · C · Packagedpg_conda · PostgreSQL extension adding conda ecosystem version types, aggregates, and functions. · 1.0.1 · Data types · MIT · Rust · Not packagedpg_crdt_jsonb · Conflict-free replicated data type operations for PostgreSQL jsonb values. · 1.0 · Data types · Unknown · C · Not packagedpg_french_datatypes · french-centric data type · 0.1.1 · Data types · PostgreSQL · SQL · Not packagedpg_hlc · PostgreSQL HLC (Hybrid Logical Clock) extension in Rust compatible with Dart CRDT library. · 0.1.0 · Data types · MIT · Rust · Not packagedpg_iban · PostgreSQL extension providing IBAN (International Bank Account Number) data type and validation functions · 1.1 · Data types · Apache-2.0 · C · Not packagedpg_nanoid · PostgreSQL extension adding a NanoID type and NanoID generation functions. · 0.0.0 · Data types · Unknown · Rust · Not packagedpg_phonenumber · C++ libphonenumber-backed phone type, equality operators, and supported-region helpers · 1.0 · Data types · Unknown · C++ · Not packagedpg_smolid · A Postgres pgrx extension adding smolid type and helper functions. · 0.1.0 · Data types · MIT · Rust · Not packagedpg_temporal · PostgreSQL extension adding Temporal ZonedDateTime support. · 1.0.0 · Data types · Unknown · Rust · Not packagedphone_number · A pgrx PostgreSQL data type and random generator for structured mobile phone numbers. · 0.0.0 · Data types · Unknown · Rust · Not packagedpostgres_security · Define a schema-local text type that duplicates PostgreSQL text storage and I/O behavior · 1.0.0 · Data types · Unknown · C · Not packagedrgb · RGB color datatype with GiST index support · 0.0.1 · Data types · Apache-2.0 · C · Not packagedseg · data type for representing line segments or floating-point intervals · 1.4 · Data types · PostgreSQL · C · Packagedsemver_rs · A semantic version data type for PostgreSQL written in Rust · 0.1.0 · Data types · MIT · Rust · Not packagedsha · This module provides datatypes for storing SHA-1, SHA-2 and MD5 hashes · 1.1.0 · Data types · PostgreSQL · C · Not packagedsoftvisio_types · PostgreSQL additional types extension · 1.2.0 · Data types · Unknown · SQL · Not packagedssn · SSN type implementation for PostgreSQL · 1.0.0 · Data types · PostgreSQL · C · Not packagedsuuid · small UUID · 0.0.1 · Data types · Apache-2.0 · C · Not packagedutinyint · One-byte unsigned integer type with casts to smallint, integer, and boolean. · 0.1.1 · Data types · PostgreSQL · C · Not packagedxml2 · XPath querying and XSLT · 1.1 · Data types · PostgreSQL · C · Packaged

132 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pglite_fusion 0.0.6 Embed an SQLite database in your PostgreSQL table TYPE MIT Rust 14–18 832
automerge 0.0.1 CRDT support in Postgres (experimental) TYPE PostgreSQL C 649
uint 1.20250815 unsigned integer types TYPE PostgreSQL C 14–18 342
uri 1.20251029 URI Data type for PostgreSQL TYPE PostgreSQL C 14–18 324
pg_rrule 0.3.0 RRULE field type for PostgreSQL TYPE MIT C 14–18 175
semver 0.41.0 Semantic version data type TYPE PostgreSQL C 14–18 168
ip4r 2.4.3 IPv4/v6 and IPv4/v6 range index type for PostgreSQL TYPE PostgreSQL C 14–18 166
pgcalendar 1.1.0 Recurring calendar, schedule, and exception management for PostgreSQL TYPE MIT SQL 14–18 141
postpic 0.9.1 A PostgreSQL image type with SQL image-processing and metadata functions, backed by GraphicsMagick, plus import/export utilities. TYPE LGPL-3.0 C 137
prefix 1.2.11 Prefix Range module for PostgreSQL TYPE PostgreSQL C 14–18 106
pgbson 2.1.0 BSON data type and accessor functions for PostgreSQL TYPE MIT C 14–18 104
emailaddr 0 Email address type for PostgreSQL TYPE C 14–18 46
pg_ferroid 2.0.0 PostgreSQL ULID type and generation functions backed by ferroid TYPE MIT Rust 13–18 44
fixeddecimal 1.1.0 Fixed-precision decimal type optimized for performance and storage. TYPE PostgreSQL C 10–18 36
postgres_web3 1.0 Optimized PostgreSQL types and operators for 128/256-bit signed and unsigned integers plus 160/256-bit hexadecimal web3 values. TYPE MIT C 15 33
uint128 1.2.0 Native uint128 type TYPE PostgreSQL C 14–18 29
tinyint 0.1.1 One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. TYPE PostgreSQL C 10 28
bignum 0.8.0 Unlimited precision integers for PostgreSQL TYPE PostgreSQL C 10–18 23
pgbitmap 0.9.5 Bitmap-type extension for PostgreSQL TYPE BSD-2-Clause C 10–18 23
currency 0.0.3 Custom PostgreSQL currency type in 1Byte TYPE MIT C 14–18 20
ccnumber 1.0 data type representing encrypted CC numbers TYPE C 18
varint 0.1.0 A signed and unsigned 64 bit integer encoding scheme that saves disk space TYPE PostgreSQL C 15
libversion 2.0.0 Version string comparison functions and versiontext type using libversion TYPE MIT C 10–16 14
crockford 0.8.34 Crockford Base32 encoded unsigned integer data types TYPE PostgreSQL C 11 13
pair 0.1.2 A key/value pair data type for PostgreSQL TYPE PostgreSQL C 10–18 12
iban 1.1 IBAN data type and validation functions for PostgreSQL TYPE GPL-3.0 C++ 14 11
inetrange 1.0.2 Range type for PostgreSQL inet values with range operators and GiST indexing support. TYPE MIT C 11
l10n_table_dependent_extension 0.8.3 PostgreSQL l10n toolbox TYPE PostgreSQL SQL 14–18 11
pg_xenophile 0.8.3 More than the bare necessities for PostgreSQL i18n and l10n. TYPE PostgreSQL SQL 14–18 11
cas_codes 0.1.0 CAS Registry Number data type and validation support for PostgreSQL. TYPE GPL-3.0 Rust 13–17 10
elements 0.1.0 Chemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx. TYPE GPL-3.0 Rust 13–17 10
iso_codes 0.1.0 ISO country code enum/data types for PostgreSQL, generated with pgrx. TYPE GPL-3.0 Rust 13–17 10
media_types 0.1.0 Strongly typed MIME media-type data type for PostgreSQL TYPE GPL-3.0 Rust 13–17 10
molecular_formulas 0.1.0 Molecular-formula parser and strongly typed PostgreSQL data type TYPE GPL-3.0 Rust 13–17 10
pg_thrift 1.0 Encode, decode, and query Apache Thrift binary and compact protocol values in PostgreSQL. TYPE C 10–11 10
pgsql_rrule 0.0.4 Pure SQL PostgreSQL data types and functions for parsing and expanding RFC 5545 recurrence rules. TYPE PostgreSQL SQL 10–18 10
country 0.0.3 Country data type, ISO 3166-1 TYPE PostgreSQL C 14–18 9
datalink 0.5.0 SQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL TYPE PostgreSQL C 10–18 9
plid 0.0.0 A 128-bit, lexicographically sortable PostgreSQL PLID type with short prefixes, millisecond timestamps, randomness, and optional monotonic generation. TYPE MIT Rust 13–18 8
telephone 0.0.1 PostgreSQL data type for normalized telephone numbers with dialing-plan validation. TYPE PostgreSQL C 10–18 8
cbor 0.1.0 Concise Binary Object Representation data type for PostgreSQL. TYPE PostgreSQL C 10–18 7
hashtypes 0.1.5 sha1, md5 and other data types for PostgreSQL TYPE PostgreSQL C 14–18 7
pg_text_semver 1.2.1 Semantic version domain and comparison operators for PostgreSQL TYPE PostgreSQL SQL 14–18 7
postbis 1.0 Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions. TYPE PostgreSQL C 14–18 7
uints 0.9 C extension providing unsigned 16-bit and 32-bit integer types with casts, operators, and numeric support functions. TYPE PostgreSQL C 7
ajbool 0.0.3 Three-valued boolean type with a pseudo-NULL unknown state for primary keys. TYPE PostgreSQL C 10–16 6
email 0.1 Email address data type with validation, equality operators, and user/domain helper functions. TYPE PostgreSQL C 10–18 6
pg_semver 0.0.1 Version(SEMVER) data type for postgresql TYPE MIT C 6
jsonb_schema 1.0 jsonb with separately stored schema TYPE PostgreSQL C 5
variant 1.0.1 Variant data type that can store values from other PostgreSQL types. TYPE BSD-2-Clause C 5