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.

automerge · 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 · 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 · Packagedprefix · Prefix Range module for PostgreSQL · 1.2.11 · Data types · PostgreSQL · C · Packagedfixeddecimal · Fixed-precision decimal type optimized for performance and storage. · 1.1.0 · Data types · PostgreSQL · 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 packagedvarint · A signed and unsigned 64 bit integer encoding scheme that saves disk space · 0.1.0 · Data types · PostgreSQL · 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 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 · 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 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 packagedjsonb_schema · jsonb with separately stored schema · 1.0 · Data types · PostgreSQL · 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 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 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 · 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 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 packagedpguri · provide indexable URI and domain-name types and URI text search · 1.0 · Data types · PostgreSQL · 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 packagedhamradio · ham radio extension · 1 · Data types · PostgreSQL · SQL · 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 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 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 packagedcitext · data type for case-insensitive character strings · 1.6 · Data types · PostgreSQL · C · 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_bikram_sambat · Bikram Sambat date type and AD/BS conversion functions · 0.1.0 · Data types · PostgreSQL · C · Packagedpg_french_datatypes · french-centric data type · 0.1.1 · Data types · PostgreSQL · SQL · Not packagedseg · data type for representing line segments or floating-point intervals · 1.4 · Data types · PostgreSQL · C · Packagedsha · This module provides datatypes for storing SHA-1, SHA-2 and MD5 hashes · 1.1.0 · Data types · PostgreSQL · C · Not packagedssn · SSN type implementation for PostgreSQL · 1.0.0 · Data types · PostgreSQL · 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

66 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
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
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
prefix 1.2.11 Prefix Range module for PostgreSQL TYPE PostgreSQL C 14–18 106
fixeddecimal 1.1.0 Fixed-precision decimal type optimized for performance and storage. TYPE PostgreSQL C 10–18 36
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
varint 0.1.0 A signed and unsigned 64 bit integer encoding scheme that saves disk space TYPE PostgreSQL C 15
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
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
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
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
jsonb_schema 1.0 jsonb with separately stored schema TYPE PostgreSQL C 5
device_type 0.0.2 Fixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes. TYPE PostgreSQL C 10–18 4
pg_erlang_term 0.0.1 PostgreSQL type for encoding, storing, and decoding Erlang External Term Format values. TYPE PostgreSQL C 3
salesforce_id 1.0 Compact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs. TYPE PostgreSQL C 3
xnode 0.7.2 Implementation of XML using DOM. TYPE PostgreSQL C 3
base32_4b 0.0.1 Base32 data type stored in four bytes with comparison operators. TYPE PostgreSQL C 10–18 2
cert 0.1.1 PostgreSQL data types and functions for X.509 certificates, certificate requests, and related OpenSSL objects. TYPE PostgreSQL C 2
chkpass 1.0 data type for auto-encrypted passwords TYPE PostgreSQL C 14–18 2
hashset 0.0.1 Provides hashset type. TYPE PostgreSQL C 2
language 0.0.4 Custom PostgreSQL language enumeration type TYPE PostgreSQL C 10–18 2
password 0.0.1 PostgreSQL data type for passwords TYPE PostgreSQL C 10–18 2
pg_genotype 1.0 Provides a compact one-byte genotype type that preserves allele order and supports insertion and deletion symbols. TYPE PostgreSQL C 2
pg_imputed_genotype 1.0 Store imputed-genotype probability triples in a packed four-byte PostgreSQL type. TYPE PostgreSQL C 2
pguri 1.0 provide indexable URI and domain-name types and URI text search TYPE PostgreSQL C 2
ajversion 0.0.1 Semantic version type for PostgreSQL backed by compact integer storage. TYPE PostgreSQL C 1
boolean_cascaded 2.0 Composite boolean status type with operators and trigger helper for cascaded parent-child status. TYPE PostgreSQL SQL 10–18 1
debversion 1.2.0 Debian version number data type TYPE PostgreSQL SQL 14–18 1
decimal 1.0 Decimal32 and decimal64 decimal floating-point data types with arithmetic and casts TYPE PostgreSQL C 1
hamradio 1 ham radio extension TYPE PostgreSQL SQL 1
pg_msgpack 0.0.1 MessagePack data type with JSON and bytea casts and access operators TYPE PostgreSQL C 1
pg_nanp 1.0 Validated and consistently formatted North American Numbering Plan data type TYPE PostgreSQL C 1
pg_postal_code_ca 1.0 an efficient, validated, formatted Canadian postal code type TYPE PostgreSQL C 1
pgopenssltypes 0.0.1 PostgreSQL extension that stores and manipulates OpenSSL cryptographic types and functionality. TYPE PostgreSQL C 10–18 1
rrule_safe 0.2.1 Memory-safe iCalendar recurrence-rule evaluation for PostgreSQL. TYPE PostgreSQL Rust 13–18 1