TYPE - Data Type

Dedicate New Data Types Like: prefix, semver, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…

Extension List

There are 37 extensions in 36 packages.

ExtensionPackageVersionLicenseLanguageDescription
prefixpg_prefix1.2.10PostgreSQLCPrefix Range module for PostgreSQL
semverpg_semver0.41.0PostgreSQLCSemantic version data type
unitpgunit7.10GPL-2.0CSI units extension
pgpdfpgpdf0.1.0GPL-3.0CPDF type with meta admin & Full-Text Search
pglite_fusionpglite_fusion0.0.6MITRustEmbed an SQLite database in your PostgreSQL table
md5hashmd5hash1.0.1BSD 2-ClauseCtype for storing 128-bit binary data inline
asn1oidasn1oid1.6GPL-3.0Casn1oid extension
roaringbitmappg_roaringbitmap1.1.0Apache-2.0Csupport for Roaring Bitmaps
pgfacetingpgfaceting0.2.0BSD 3-ClauseSQLfast faceting queries using an inverted index
pg_spherepgsphere1.5.2BSD 3-ClauseCspherical objects with useful functions, operators and index support
countrypg_country0.0.3PostgreSQLCCountry data type, ISO 3166-1
pg_xenophilepg_xenophile0.8.3PostgreSQLSQLMore than the bare necessities for PostgreSQL i18n and l10n.
l10n_table_dependent_extensionpg_xenophile0.8.3PostgreSQLSQLPostgreSQL l10n toolbox
currencypg_currency0.0.3MITCCustom PostgreSQL currency type in 1Byte
collectionpgcollection1.1.1Apache-2.0CMemory optimized data type to be used inside of plpglsql func
pgmppgmp1.0.5LGPL-3.0CMultiple Precision Arithmetic extension
numeralnumeral1.3GPL-2.0Cnumeral datatypes extension
pg_rationalpg_rational0.0.2MITCbigint fractions
uintpguint1.20250815PostgreSQLCunsigned integer types
uint128pg_uint1281.2.0PostgreSQLCNative uint128 type
hashtypeshashtypes0.1.5PostgreSQLCsha1, md5 and other data types for PostgreSQL
ip4rip4r2.4.2PostgreSQLCIPv4/v6 and IPv4/v6 range index type for PostgreSQL
pg_durationpg_duration1.0.2MITCdata type for representing durations
uripg_uri1.20251029PostgreSQLCURI Data type for PostgreSQL
emailaddrpg_emailaddr0PostgreSQLCEmail address type for PostgreSQL
aclpg_acl1.0.4BSD 2-ClauseCACL Data type
debversiondebversion1.2.0PostgreSQLSQLDebian version number data type
pg_rrulepg_rrule0.3.0MITCRRULE field type for PostgreSQL
timestamp9timestamp91.4.0MITCtimestamp nanosecond resolution
chkpasschkpass1.0PostgreSQLCdata type for auto-encrypted passwords
isnisn1.2PostgreSQLCdata types for international product numbering standards
segseg1.4PostgreSQLCdata type for representing line segments or floating-point intervals
cubecube1.5PostgreSQLCdata type for multidimensional cubes
ltreeltree1.3PostgreSQLCdata type for hierarchical tree-like structures
hstorehstore1.8PostgreSQLCdata type for storing sets of (key, value) pairs
citextcitext1.6PostgreSQLCdata type for case-insensitive character strings
xml2xml21.1PostgreSQLCXPath querying and XSLT

prefix

pg_prefix - 1.2.10 : Prefix Range module for PostgreSQL

ItemValueOSx86_64aarch64
Extensionprefixel818171615141817161514
Packagepg_prefixel918171615141817161514
RPMprefix_$vel1018171615141817161514
DEBpostgresql-$v-prefixd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

semver

pg_semver - 0.41.0 : Semantic version data type

ItemValueOSx86_64aarch64
Extensionsemverel818171615141817161514
Packagepg_semverel918171615141817161514
RPMsemver_$vel1018171615141817161514
DEBpostgresql-$v-semverd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

unit

pgunit - 7.10 : SI units extension

ItemValueOSx86_64aarch64
Extensionunitel818171615141817161514
Packagepgunitel918171615141817161514
RPMpostgresql-unit_$vel1018171615141817161514
DEBpostgresql-$v-unitd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicenseGPL-2.0u2418171615141817161514

pgpdf

pgpdf - 0.1.0 : PDF type with meta admin & Full-Text Search

ItemValueOSx86_64aarch64
Extensionpgpdfel818171615141817161514
Packagepgpdfel918171615141817161514
RPMpgpdf_$vel1018171615141817161514
DEBpostgresql-$v-pgpdfd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseGPL-3.0u2418171615141817161514

pglite_fusion

pglite_fusion - 0.0.6 : Embed an SQLite database in your PostgreSQL table

ItemValueOSx86_64aarch64
Extensionpglite_fusionel818171615141817161514
Packagepglite_fusionel918171615141817161514
RPMpglite_fusion_$vel1018171615141817161514
DEBpostgresql-$v-pglite-fusiond1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

md5hash

md5hash - 1.0.1 : type for storing 128-bit binary data inline

ItemValueOSx86_64aarch64
Extensionmd5hashel818171615141817161514
Packagemd5hashel918171615141817161514
RPMmd5hash_$vel1018171615141817161514
DEBpostgresql-$v-md5hashd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseBSD 2-Clauseu2418171615141817161514

asn1oid

asn1oid - 1.6 : asn1oid extension

ItemValueOSx86_64aarch64
Extensionasn1oidel818171615141817161514
Packageasn1oidel918171615141817161514
RPMasn1oid_$vel1018171615141817161514
DEBpostgresql-$v-asn1oidd1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseGPL-3.0u2418171615141817161514

roaringbitmap

pg_roaringbitmap - 1.1.0 : support for Roaring Bitmaps

ItemValueOSx86_64aarch64
Extensionroaringbitmapel818171615141817161514
Packagepg_roaringbitmapel918171615141817161514
RPMpg_roaringbitmap_$vel1018171615141817161514
DEBpostgresql-$v-roaringbitmapd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

pgfaceting

pgfaceting - 0.2.0 : fast faceting queries using an inverted index

ItemValueOSx86_64aarch64
Extensionpgfacetingel818171615141817161514
Packagepgfacetingel918171615141817161514
RPMpgfaceting_$vel1018171615141817161514
DEBpostgresql-$v-pgfacetingd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseBSD 3-Clauseu2418171615141817161514

pg_sphere

pgsphere - 1.5.2 : spherical objects with useful functions, operators and index support

ItemValueOSx86_64aarch64
Extensionpg_sphereel818171615141817161514
Packagepgsphereel918171615141817161514
RPMpgsphere_$vel1018171615141817161514
DEBpostgresql-$v-pgsphered1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseBSD 3-Clauseu2418171615141817161514

country

pg_country - 0.0.3 : Country data type, ISO 3166-1

ItemValueOSx86_64aarch64
Extensioncountryel818171615141817161514
Packagepg_countryel918171615141817161514
RPMpg_country_$vel1018171615141817161514
DEBpostgresql-$v-pg-countryd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_xenophile

pg_xenophile - 0.8.3 : More than the bare necessities for PostgreSQL i18n and l10n.

ItemValueOSx86_64aarch64
Extensionpg_xenophileel818171615141817161514
Packagepg_xenophileel918171615141817161514
RPMpg_xenophile_$vel1018171615141817161514
DEBpostgresql-$v-pg-xenophiled1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

l10n_table_dependent_extension

pg_xenophile - 0.8.3 : PostgreSQL l10n toolbox

ItemValueOSx86_64aarch64
Extensionl10n_table_dependent_extensionel818171615141817161514
Packagepg_xenophileel918171615141817161514
RPMpg_xenophile_$vel1018171615141817161514
DEBpostgresql-$v-pg-xenophiled1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

currency

pg_currency - 0.0.3 : Custom PostgreSQL currency type in 1Byte

ItemValueOSx86_64aarch64
Extensioncurrencyel818171615141817161514
Packagepg_currencyel918171615141817161514
RPMpg_currency_$vel1018171615141817161514
DEBpostgresql-$v-pg-currencyd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

collection

pgcollection - 1.1.1 : Memory optimized data type to be used inside of plpglsql func

ItemValueOSx86_64aarch64
Extensioncollectionel818171615141817161514
Packagepgcollectionel918171615141817161514
RPMpgcollection_$vel1018171615141817161514
DEBpostgresql-$v-collectiond1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

pgmp

pgmp - 1.0.5 : Multiple Precision Arithmetic extension

ItemValueOSx86_64aarch64
Extensionpgmpel818171615141817161514
Packagepgmpel918171615141817161514
RPMpgmp_$vel1018171615141817161514
DEBpostgresql-$v-pgmpd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicenseLGPL-3.0u2418171615141817161514

numeral

numeral - 1.3 : numeral datatypes extension

ItemValueOSx86_64aarch64
Extensionnumeralel818171615141817161514
Packagenumeralel918171615141817161514
RPMnumeral_$vel1018171615141817161514
DEBpostgresql-$v-numerald1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseGPL-2.0u2418171615141817161514

pg_rational

pg_rational - 0.0.2 : bigint fractions

ItemValueOSx86_64aarch64
Extensionpg_rationalel818171615141817161514
Packagepg_rationalel918171615141817161514
RPMpg_rational_$vel1018171615141817161514
DEBpostgresql-$v-rationald1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseMITu2418171615141817161514

uint

pguint - 1.20250815 : unsigned integer types

ItemValueOSx86_64aarch64
Extensionuintel818171615141817161514
Packagepguintel918171615141817161514
RPMpguint_$vel1018171615141817161514
DEBpostgresql-$v-pguintd1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

uint128

pg_uint128 - 1.2.0 : Native uint128 type

ItemValueOSx86_64aarch64
Extensionuint128el818171615141817161514
Packagepg_uint128el918171615141817161514
RPMpg_uint128_$vel1018171615141817161514
DEBpostgresql-$v-pg-uint128d1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hashtypes

hashtypes - 0.1.5 : sha1, md5 and other data types for PostgreSQL

ItemValueOSx86_64aarch64
Extensionhashtypesel818171615141817161514
Packagehashtypesel918171615141817161514
RPMhashtypes_$vel1018171615141817161514
DEBpostgresql-$v-hashtypesd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

ip4r

ip4r - 2.4.2 : IPv4/v6 and IPv4/v6 range index type for PostgreSQL

ItemValueOSx86_64aarch64
Extensionip4rel818171615141817161514
Packageip4rel918171615141817161514
RPMip4r_$vel1018171615141817161514
DEBpostgresql-$v-ip4rd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_duration

pg_duration - 1.0.2 : data type for representing durations

ItemValueOSx86_64aarch64
Extensionpg_durationel818171615141817161514
Packagepg_durationel918171615141817161514
RPMpg_duration_$vel1018171615141817161514
DEBpostgresql-$v-pg-durationd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

uri

pg_uri - 1.20251029 : URI Data type for PostgreSQL

ItemValueOSx86_64aarch64
Extensionuriel818171615141817161514
Packagepg_uriel918171615141817161514
RPMpg_uri_$vel1018171615141817161514
DEBpostgresql-$v-pg-urid1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

emailaddr

pg_emailaddr - 0 : Email address type for PostgreSQL

ItemValueOSx86_64aarch64
Extensionemailaddrel818171615141817161514
Packagepg_emailaddrel918171615141817161514
RPMpg_emailaddr_$vel1018171615141817161514
DEBpostgresql-$v-pg-emailaddrd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

acl

pg_acl - 1.0.4 : ACL Data type

ItemValueOSx86_64aarch64
Extensionaclel818171615141817161514
Packagepg_aclel918171615141817161514
RPMacl_$vel1018171615141817161514
DEBpostgresql-$v-acld1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseBSD 2-Clauseu2418171615141817161514

debversion

debversion - 1.2.0 : Debian version number data type

ItemValueOSx86_64aarch64
Extensiondebversionel8--
Packagedebversionel9--
RPM-el10--
DEBpostgresql-$v-debversiond1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPGDGu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_rrule

pg_rrule - 0.3.0 : RRULE field type for PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_rruleel818171615141817161514
Packagepg_rruleel918171615141817161514
RPMpg_rrule_$vel1018171615141817161514
DEBpostgresql-$v-pg-rruled1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseMITu2418171615141817161514

timestamp9

timestamp9 - 1.4.0 : timestamp nanosecond resolution

ItemValueOSx86_64aarch64
Extensiontimestamp9el818171615141817161514
Packagetimestamp9el918171615141817161514
RPMtimestamp9_$vel1018171615141817161514
DEBpostgresql-$v-timestamp9d1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseMITu2418171615141817161514

chkpass

chkpass - 1.0 : data type for auto-encrypted passwords

ItemValueOSx86_64aarch64
Extensionchkpassel818171615141817161514
Packagechkpassel918171615141817161514
RPMchkpass_$vel1018171615141817161514
DEBpostgresql-$v-chkpassd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

isn

isn - 1.2 : data types for international product numbering standards

ItemValueOSx86_64aarch64
Extensionisnel818171615141817161514
Packageisnel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

seg

seg - 1.4 : data type for representing line segments or floating-point intervals

ItemValueOSx86_64aarch64
Extensionsegel818171615141817161514
Packagesegel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

cube

cube - 1.5 : data type for multidimensional cubes

ItemValueOSx86_64aarch64
Extensioncubeel818171615141817161514
Packagecubeel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

ltree

ltree - 1.3 : data type for hierarchical tree-like structures

ItemValueOSx86_64aarch64
Extensionltreeel818171615141817161514
Packageltreeel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hstore

hstore - 1.8 : data type for storing sets of (key, value) pairs

ItemValueOSx86_64aarch64
Extensionhstoreel818171615141817161514
Packagehstoreel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

citext

citext - 1.6 : data type for case-insensitive character strings

ItemValueOSx86_64aarch64
Extensioncitextel818171615141817161514
Packagecitextel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

xml2

xml2 - 1.1 : XPath querying and XSLT

ItemValueOSx86_64aarch64
Extensionxml2el818171615141817161514
Packagexml2el918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

Last Modified 2026-03-12: add pg extension catalog (95749bf)