Category: TYPE

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

TYPE category has 30 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
prefix prefix PGDG 1.2.0 TYPE PostgreSQL Prefix Range module for PostgreSQL
semver semver PGDG 0.32.1 TYPE PostgreSQL Semantic version data type
unit pgunit PGDG 7 TYPE GPLv3 SI units extension
md5hash md5hash PIGSTY 1.0.1 TYPE BSD 2 type for storing 128-bit binary data inline
asn1oid asn1oid PIGSTY 1 TYPE GPLv3 asn1oid extension
roaringbitmap roaringbitmap PIGSTY 0.5 TYPE Apache-2.0 support for Roaring Bitmaps
pgfaceting pgfaceting PIGSTY 0.2.0 TYPE BSD 3 fast faceting queries using an inverted index
pg_sphere pgsphere PIGSTY 1.5.1 TYPE BSD 3 spherical objects with useful functions, operators and index support
country pg_country PIGSTY 0.0.3 TYPE PostgreSQL Country data type, ISO 3166-1
currency pg_currency PIGSTY 0.0.3 TYPE MIT Custom PostgreSQL currency type in 1Byte
pgmp pgmp PGDG 1.1 TYPE LGPLv3 Multiple Precision Arithmetic extension
numeral numeral PIGSTY 1 TYPE GPLv2 numeral datatypes extension
pg_rational pg_rational PIGSTY 0.0.2 TYPE MIT bigint fractions
uint pguint PGDG 0 TYPE PostgreSQL unsigned integer types
uint128 pg_uint128 PIGSTY 1.0.0 TYPE PostgreSQL Native uint128 type
ip4r ip4r PGDG 2.4 TYPE PostgreSQL IPv4/v6 and IPv4/v6 range index type for PostgreSQL
uri pg_uri PIGSTY 1 TYPE PostgreSQL URI Data type for PostgreSQL
pgemailaddr pgemailaddr PIGSTY 0 TYPE PostgreSQL Email address type for PostgreSQL
acl acl PIGSTY 1.0.4 TYPE BSD-2 ACL Data type
debversion debversion PGDG 1.2 TYPE PostgreSQL Debian version number data type
pg_rrule pg_rrule PGDG 0.2.0 TYPE MIT RRULE field type for PostgreSQL
timestamp9 timestamp9 PGDG 1.4.0 TYPE MIT timestamp nanosecond resolution
chkpass chkpass PIGSTY 1.0 TYPE PostgreSQL data type for auto-encrypted passwords
isn isn CONTRIB 1.2 TYPE PostgreSQL data types for international product numbering standards
seg seg CONTRIB 1.4 TYPE PostgreSQL data type for representing line segments or floating-point intervals
cube cube CONTRIB 1.5 TYPE PostgreSQL data type for multidimensional cubes
ltree ltree CONTRIB 1.2 TYPE PostgreSQL data type for hierarchical tree-like structures
hstore hstore CONTRIB 1.8 TYPE PostgreSQL data type for storing sets of (key, value) pairs
citext citext CONTRIB 1.6 TYPE PostgreSQL data type for case-insensitive character strings
xml2 xml2 CONTRIB 1.1 TYPE PostgreSQL XPath querying and XSLT

prefix

Prefix Range module for PostgreSQL

semver

Semantic version data type

unit

SI units extension

md5hash

type for storing 128-bit binary data inline

asn1oid

asn1oid extension

roaringbitmap

support for Roaring Bitmaps

pgfaceting

fast faceting queries using an inverted index

pg_sphere

spherical objects with useful functions, operators and index support

country

Country data type, ISO 3166-1

currency

Custom PostgreSQL currency type in 1Byte

pgmp

Multiple Precision Arithmetic extension

numeral

numeral datatypes extension

pg_rational

bigint fractions

uint

unsigned integer types

uint128

Native uint128 type

ip4r

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

uri

URI Data type for PostgreSQL

pgemailaddr

Email address type for PostgreSQL

acl

ACL Data type

debversion

Debian version number data type

pg_rrule

RRULE field type for PostgreSQL

timestamp9

timestamp nanosecond resolution

chkpass

data type for auto-encrypted passwords

isn

data types for international product numbering standards

seg

data type for representing line segments or floating-point intervals

cube

data type for multidimensional cubes

ltree

data type for hierarchical tree-like structures

hstore

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

citext

data type for case-insensitive character strings

xml2

XPath querying and XSLT


Last modified 2024-10-24: add pg17 support ext info (3134bfbd)