prefix
Prefix Range module for PostgreSQL
Category: TYPE
TYPE: Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…
Module:
Categories:
TYPE category has 35 available extensions:
| Name (Detail) | Package (Repo) | Repo | Version | Category | License | LOAD |
DDL |
TRUST |
RELOC |
Description |
|---|---|---|---|---|---|---|---|---|---|---|
| prefix | pg_prefix |
PGDG | 1.2.0 | TYPE |
PostgreSQL | Prefix Range module for PostgreSQL | ||||
| semver | pg_semver |
PGDG | 0.32.1 | TYPE |
PostgreSQL | Semantic version data type | ||||
| unit | pgunit |
PGDG | 7 | TYPE |
GPLv2 | SI units extension | ||||
| pgpdf | pgpdf |
PIGSTY | 0.1.0 | TYPE |
GPLv3 | PDF type with meta admin & Full-Text Search | ||||
| pglite_fusion | pglite_fusion |
PIGSTY | 0.0.3 | TYPE |
MIT | Embed an SQLite database in your PostgreSQL table | ||||
| md5hash | md5hash |
PIGSTY | 1.0.1 | TYPE |
BSD 2 | type for storing 128-bit binary data inline | ||||
| asn1oid | asn1oid |
MIXED | 1 | TYPE |
GPLv3 | asn1oid extension | ||||
| roaringbitmap | roaringbitmap |
MIXED | 0.5 | TYPE |
Apache-2.0 | support for Roaring Bitmaps | ||||
| pgfaceting | pgfaceting |
MIXED | 0.2.0 | TYPE |
BSD 3 | fast faceting queries using an inverted index | ||||
| pg_sphere | pgsphere |
MIXED | 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 | ||||
| pg_xenophile | pg_xenophile |
PIGSTY | 0.8.3 | TYPE |
PostgreSQL | More than the bare necessities for PostgreSQL i18n and l10n. | ||||
| 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 |
MIXED | 1 | TYPE |
GPLv2 | numeral datatypes extension | ||||
| pg_rational | pg_rational |
MIXED | 0.0.2 | TYPE |
MIT | bigint fractions | ||||
| uint | pguint |
MIXED | 0 | TYPE |
PostgreSQL | unsigned integer types | ||||
| uint128 | pg_uint128 |
PIGSTY | 1.0.0 | TYPE |
PostgreSQL | Native uint128 type | ||||
| hashtypes | hashtypes |
PIGSTY | 0.1.5 | TYPE |
PostgreSQL | sha1, md5 and other data types for PostgreSQL | ||||
| ip4r | ip4r |
PGDG | 2.4 | TYPE |
PostgreSQL | IPv4/v6 and IPv4/v6 range index type for PostgreSQL | ||||
| pg_duration | pg_duration |
PIGSTY | 1.0.1 | TYPE |
MIT | data type for representing durations | ||||
| uri | pg_uri |
PIGSTY | 1 | TYPE |
PostgreSQL | URI Data type for PostgreSQL | ||||
| emailaddr | pgemailaddr |
PIGSTY | 0 | TYPE |
PostgreSQL | Email address type for PostgreSQL | ||||
| acl | pg_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 |
MIXED | 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.3 | 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 |
semver
Semantic version data type
unit
SI units extension
pgpdf
PDF type with meta admin & Full-Text Search
pglite_fusion
Embed an SQLite database in your PostgreSQL table
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
pg_xenophile
More than the bare necessities for PostgreSQL i18n and l10n.
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
hashtypes
sha1, md5 and other data types for PostgreSQL
ip4r
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
pg_duration
data type for representing durations
uri
URI Data type for PostgreSQL
emailaddr
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
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.