PIGSTY

TYPE

Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule

TYPE category contains 37 PostgreSQL extensions.

IDExtensionPackageVersionDescription
3500prefixpg_prefix1.2.10Prefix Range module for PostgreSQL
3510semverpg_semver0.40.0Semantic version data type
3520unitpgunit7.10SI units extension
3530pgpdfpgpdf0.1.0PDF type with meta admin & Full-Text Search
3540pglite_fusionpglite_fusion0.0.5Embed an SQLite database in your PostgreSQL table
3550md5hashmd5hash1.0.1type for storing 128-bit binary data inline
3560asn1oidasn1oid1.6asn1oid extension
3570roaringbitmaproaringbitmap0.5.4support for Roaring Bitmaps
3580pgfacetingpgfaceting0.2.0fast faceting queries using an inverted index
3590pg_spherepgsphere1.5.1spherical objects with useful functions, operators and index support
3600countrypg_country0.0.3Country data type, ISO 3166-1
3610pg_xenophilepg_xenophile0.8.3More than the bare necessities for PostgreSQL i18n and l10n.
3611l10n_table_dependent_extensionpg_xenophile0.8.3PostgreSQL l10n toolbox
3620currencypg_currency0.0.3Custom PostgreSQL currency type in 1Byte
3630collectionpg_collection1.0.0Memory optimized data type to be used inside of plpglsql func
3700pgmppgmp1.0.5Multiple Precision Arithmetic extension
3710numeralnumeral1.3numeral datatypes extension
3720pg_rationalpg_rational0.0.2bigint fractions
3730uintpguint1.20231206unsigned integer types
3740uint128pg_uint1281.0.0Native uint128 type
3750hashtypeshashtypes0.1.5sha1, md5 and other data types for PostgreSQL
3820ip4rip4r2.4.2IPv4/v6 and IPv4/v6 range index type for PostgreSQL
3830pg_durationpg_duration1.0.2data type for representing durations
3840uripg_uri1.20151224URI Data type for PostgreSQL
3850emailaddrpgemailaddr0Email address type for PostgreSQL
3860aclpg_acl1.0.4ACL Data type
3870debversiondebversion1.2.0Debian version number data type
3880pg_rrulepg_rrule0.2.0RRULE field type for PostgreSQL
3890timestamp9timestamp91.4.0timestamp nanosecond resolution
3920chkpasschkpass1.0data type for auto-encrypted passwords
3930isnisn1.2data types for international product numbering standards
3940segseg1.4data type for representing line segments or floating-point intervals
3950cubecube1.5data type for multidimensional cubes
3960ltreeltree1.3data type for hierarchical tree-like structures
3970hstorehstore1.8data type for storing sets of (key, value) pairs
3980citextcitext1.6data type for case-insensitive character strings
3990xml2xml21.1XPath querying and XSLT

prefix - 1.2.10

Prefix Range module for PostgreSQL

ExtensionWebsiteAttributes
Packagepg_prefix
RPMprefix_$v*
DDL
DEBpostgresql-$v-prefix
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

semver - 0.40.0

Semantic version data type

ExtensionWebsiteAttributes
Packagepg_semver
RPMsemver_$v*
DDL
DEBpostgresql-$v-semver
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

unit - 7.10

SI units extension

ExtensionWebsiteAttributes
Packagepgunit
RPMpostgresql-unit_$v*
DDL
DEBpostgresql-$v-unit
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgpdf - 0.1.0

PDF type with meta admin & Full-Text Search

ExtensionWebsiteAttributes
Packagepgpdf
LOAD
RPMpgpdf_$v*
DDL
DEBpostgresql-$v-pgpdf
LIB
Language
C
License
GPL-3.0
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pglite_fusion - 0.0.5

Embed an SQLite database in your PostgreSQL table

ExtensionWebsiteAttributes
Packagepglite_fusion
LOAD
RPMpglite_fusion_$v
DDL
DEBpostgresql-$v-pglite-fusion
LIB
Language
Rust
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

md5hash - 1.0.1

type for storing 128-bit binary data inline

ExtensionWebsiteAttributes
Packagemd5hash
RPMmd5hash_$v*
DDL
DEBpostgresql-$v-md5hash
LIB
Language
C
License
BSD 2-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

asn1oid - 1.6

asn1oid extension

ExtensionWebsiteAttributes
Packageasn1oid
RPMasn1oid_$v*
DDL
DEBpostgresql-$v-asn1oid
LIB
Language
C
License
GPL-3.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

roaringbitmap - 0.5.4

support for Roaring Bitmaps

ExtensionWebsiteAttributes
Packageroaringbitmap
RPMpg_roaringbitmap_$v*
DDL
DEBpostgresql-$v-roaringbitmap
LIB
Language
C
License
Apache-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgfaceting - 0.2.0

fast faceting queries using an inverted index

ExtensionWebsiteAttributes
Packagepgfaceting
RPMpgfaceting_$v
DDL
DEBpostgresql-$v-pgfaceting
Language
SQL
License
BSD 3-Clause
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_sphere - 1.5.1

spherical objects with useful functions, operators and index support

ExtensionWebsiteAttributes
Packagepgsphere
RPMpgsphere_$v*
DDL
DEBpostgresql-$v-pgsphere
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

country - 0.0.3

Country data type, ISO 3166-1

ExtensionWebsiteAttributes
Packagepg_country
RPMpg_country_$v*
DDL
DEBpostgresql-$v-pg-country
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_xenophile - 0.8.3

More than the bare necessities for PostgreSQL i18n and l10n.

ExtensionWebsiteAttributes
Packagepg_xenophile
RPMpg_xenophile_$v
DDL
DEBpostgresql-$v-pg-xenophile
Language
SQL
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

l10n_table_dependent_extension - 0.8.3

PostgreSQL l10n toolbox

ExtensionWebsiteAttributes
Packagepg_xenophile
RPMpg_xenophile_$v
DDL
DEBpostgresql-$v-pg-xenophile
Language
SQL
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

currency - 0.0.3

Custom PostgreSQL currency type in 1Byte

ExtensionWebsiteAttributes
Packagepg_currency
RPMpg_currency_$v*
DDL
DEBpostgresql-$v-pg-currency
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

collection - 1.0.0

Memory optimized data type to be used inside of plpglsql func

ExtensionWebsiteAttributes
Packagepg_collection
RPMpgcollection_$v*
DDL
DEBpostgresql-$v-collection
LIB
Language
C
License
Apache-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgmp - 1.0.5

Multiple Precision Arithmetic extension

ExtensionWebsiteAttributes
Packagepgmp
RPMpgmp_$v*
DDL
DEBpostgresql-$v-pgmp
LIB
Language
C
License
LGPL-3.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

numeral - 1.3

numeral datatypes extension

ExtensionWebsiteAttributes
Packagenumeral
RPMnumeral_$v*
DDL
DEBpostgresql-$v-numeral
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_rational - 0.0.2

bigint fractions

ExtensionWebsiteAttributes
Packagepg_rational
RPMpg_rational_$v*
DDL
DEBpostgresql-$v-rational
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

uint - 1.20231206

unsigned integer types

ExtensionWebsiteAttributes
Packagepguint
RPMpguint_$v*
DDL
DEBpostgresql-$v-pguint
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

uint128 - 1.0.0

Native uint128 type

ExtensionWebsiteAttributes
Packagepg_uint128
RPMpg_uint128_$v*
DDL
DEBpostgresql-$v-pg-uint128
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hashtypes - 0.1.5

sha1, md5 and other data types for PostgreSQL

ExtensionWebsiteAttributes
Packagehashtypes
RPMhashtypes_$v*
DDL
DEBpostgresql-$v-hashtypes
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

ip4r - 2.4.2

IPv4/v6 and IPv4/v6 range index type for PostgreSQL

ExtensionWebsiteAttributes
Packageip4r
RPMip4r_$v*
DDL
DEBpostgresql-$v-ip4r
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_duration - 1.0.2

data type for representing durations

ExtensionWebsiteAttributes
Packagepg_duration
RPMpg_duration_$v*
DDL
DEBpostgresql-$v-pg-duration
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

uri - 1.20151224

URI Data type for PostgreSQL

ExtensionWebsiteAttributes
Packagepg_uri
RPMpg_uri_$v*
DDL
DEBpostgresql-$v-pg-uri
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

emailaddr - 0

Email address type for PostgreSQL

ExtensionWebsiteAttributes
Packagepgemailaddr
RPMpg_emailaddr_$v*
DDL
DEBpostgresql-$v-pg-emailaddr
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

acl - 1.0.4

ACL Data type

ExtensionWebsiteAttributes
Packagepg_acl
RPMacl_$v*
DDL
DEBpostgresql-$v-acl
LIB
Language
C
License
BSD 2-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

debversion - 1.2.0

Debian version number data type

ExtensionWebsiteAttributes
Packagedebversion
RPMN/A
DDL
DEBpostgresql-$v-debversion
LIB
Language
SQL
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_rrule - 0.2.0

RRULE field type for PostgreSQL

ExtensionWebsiteAttributes
Packagepg_rrule
RPMN/A
DDL
DEBpostgresql-$v-pg-rrule
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

timestamp9 - 1.4.0

timestamp nanosecond resolution

ExtensionWebsiteAttributes
Packagetimestamp9
RPMtimestamp9_$v*
DDL
DEBpostgresql-$v-timestamp9
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

chkpass - 1.0

data type for auto-encrypted passwords

ExtensionWebsiteAttributes
Packagechkpass
RPMchkpass_$v*
DDL
DEBpostgresql-$v-chkpass
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

isn - 1.2

data types for international product numbering standards

ExtensionWebsiteAttributes
Packageisn
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

seg - 1.4

data type for representing line segments or floating-point intervals

ExtensionWebsiteAttributes
Packageseg
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

cube - 1.5

data type for multidimensional cubes

ExtensionWebsiteAttributes
Packagecube
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

ltree - 1.3

data type for hierarchical tree-like structures

ExtensionWebsiteAttributes
Packageltree
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hstore - 1.8

data type for storing sets of (key, value) pairs

ExtensionWebsiteAttributes
Packagehstore
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

citext - 1.6

data type for case-insensitive character strings

ExtensionWebsiteAttributes
Packagecitext
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

xml2 - 1.1

XPath querying and XSLT

ExtensionWebsiteAttributes
Packagexml2
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13