This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
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:
1 - prefix
Prefix Range module for PostgreSQL
Overview
PGDG 1st Party Extension: prefix
: Prefix Range module for PostgreSQL
- Version: 1.2.0
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
prefix_$v*
- RPM Ver :
1.2.0
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-prefix
- DEB Ver :
1.2.0
- DEB Deps: Nil
Details
2 - semver
Semantic version data type
Overview
PGDG 1st Party Extension: semver
: Semantic version data type
- Version: 0.32.1
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
semver_$v*
- RPM Ver :
0.32.1
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-semver
- DEB Ver :
0.40.0
- DEB Deps: Nil
Details
3 - unit
SI units extension
Overview
PGDG 1st Party Extension: pgunit
: SI units extension
- Version: 7
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
plpgsql
Packages
- RPM Repo: PGDG
- RPM Name:
postgresql-unit_$v*
- RPM Ver :
7
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-unit
- DEB Ver :
7
- DEB Deps: Nil
Details
4 - md5hash
type for storing 128-bit binary data inline
Overview
PIGSTY 3rd Party Extension: md5hash
: type for storing 128-bit binary data inline
- Version: 1.0.1
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
md5hash_$v*
- RPM Ver :
1.0.1
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-md5hash
- DEB Ver :
1.0.1
- DEB Deps: Nil
Details
5 - asn1oid
asn1oid extension
Overview
PIGSTY 3rd Party Extension: asn1oid
: asn1oid extension
- Version: 1
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
asn1oid_$v*
- RPM Ver :
1
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-asn1oid
- DEB Ver :
1
- DEB Deps: Nil
Details
6 - roaringbitmap
support for Roaring Bitmaps
Overview
PIGSTY 3rd Party Extension: roaringbitmap
: support for Roaring Bitmaps
- Version: 0.5
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_roaringbitmap_$v*
- RPM Ver :
0.5
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-roaringbitmap
- DEB Ver :
0.5
- DEB Deps: Nil
Details
7 - pgfaceting
fast faceting queries using an inverted index
Overview
PIGSTY 3rd Party Extension: pgfaceting
: fast faceting queries using an inverted index
- Version: 0.2.0
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Relocatable
- Trusted: Trusted, Can be created by user with
CREATE
Privilege
- Schemas:
faceting
- Requires:
roaringbitmap
Packages
- RPM Repo: PIGSTY
- RPM Name:
pgfaceting_$v
- RPM Ver :
0.2.0
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgfaceting
- DEB Ver :
0.2.0
- DEB Deps: Nil
Details
8 - pg_sphere
spherical objects with useful functions, operators and index support
Overview
PIGSTY 3rd Party Extension: pgsphere
: spherical objects with useful functions, operators and index support
- Version: 1.5.1
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pgsphere_$v*
- RPM Ver :
1.5.1
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgsphere
- DEB Ver :
1.5.1
- DEB Deps: Nil
Details
9 - country
Country data type, ISO 3166-1
Overview
PIGSTY 3rd Party Extension: pg_country
: Country data type, ISO 3166-1
- Version: 0.0.3
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_country_$v*
- RPM Ver :
0.0.3
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-country
- DEB Ver :
0.0.3
- DEB Deps: Nil
Details
10 - currency
Custom PostgreSQL currency type in 1Byte
Overview
PIGSTY 3rd Party Extension: pg_currency
: Custom PostgreSQL currency type in 1Byte
- Version: 0.0.3
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_currency_$v*
- RPM Ver :
0.0.3
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-currency
- DEB Ver :
0.0.3
- DEB Deps: Nil
Details
11 - pgmp
Multiple Precision Arithmetic extension
Overview
PGDG 1st Party Extension: pgmp
: Multiple Precision Arithmetic extension
- Version: 1.1
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pgmp_$v*
- RPM Ver :
1.1
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgmp
- DEB Ver :
1.1
- DEB Deps: Nil
Details
12 - numeral
numeral datatypes extension
Overview
PIGSTY 3rd Party Extension: numeral
: numeral datatypes extension
- Version: 1
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
numeral_$v*
- RPM Ver :
1
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-numeral
- DEB Ver :
1
- DEB Deps: Nil
Details
13 - pg_rational
bigint fractions
Overview
PIGSTY 3rd Party Extension: pg_rational
: bigint fractions
- Version: 0.0.2
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_rational_$v*
- RPM Ver :
0.0.2
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-rational
- DEB Ver :
0.0.1
- DEB Deps: Nil
Details
14 - uint
unsigned integer types
Overview
PGDG 3rd Party Extension: pguint
: unsigned integer types
- Version: 0
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pguint_$v*
- RPM Ver :
0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pguint
- DEB Ver :
0
- DEB Deps: Nil
Details
15 - uint128
Native uint128 type
Overview
PIGSTY 3rd Party Extension: pg_uint128
: Native uint128 type
- Version: 1.0.0
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_uint128_$v*
- RPM Ver :
1.0.0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-uint128
- DEB Ver :
1.0.0
- DEB Deps: Nil
Details
16 - ip4r
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
Overview
PGDG 1st Party Extension: ip4r
: IPv4/v6 and IPv4/v6 range index type for PostgreSQL
- Version: 2.4
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
ip4r_$v*
- RPM Ver :
2.4
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-ip4r
- DEB Ver :
2.4
- DEB Deps: Nil
Details
17 - uri
URI Data type for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pg_uri
: URI Data type for PostgreSQL
- Version: 1
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_uri_$v*
- RPM Ver :
1
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-uri
- DEB Ver :
1
- DEB Deps: Nil
Details
18 - pgemailaddr
Email address type for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pgemailaddr
: Email address type for PostgreSQL
- Version: 0
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_emailaddr_$v*
- RPM Ver :
0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v$v-pg-emailaddr
- DEB Ver :
0
- DEB Deps: Nil
Details
19 - acl
ACL Data type
Overview
PIGSTY 3rd Party Extension: acl
: ACL Data type
- Version: 1.0.4
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
acl_$v*
- RPM Ver :
1.0.4
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-acl
- DEB Ver :
1.0.4
- DEB Deps: Nil
Details
20 - debversion
Debian version number data type
Overview
PGDG 1st Party Extension: debversion
: Debian version number data type
- Version: 1.2
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: N/A
- RPM Name:
N/A
- RPM Ver : N/A
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-debversion
- DEB Ver :
1.2
- DEB Deps: Nil
Details
21 - pg_rrule
RRULE field type for PostgreSQL
Overview
PGDG 1st Party Extension: pg_rrule
: RRULE field type for PostgreSQL
- Version: 0.2.0
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: N/A
- RPM Name:
N/A
- RPM Ver : N/A
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-rrule
- DEB Ver :
0.2.0
- DEB Deps: Nil
Details
22 - timestamp9
timestamp nanosecond resolution
Overview
PGDG 3rd Party Extension: timestamp9
: timestamp nanosecond resolution
- Version: 1.4.0
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
timestamp9_$v*
- RPM Ver :
1.4.0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-timestamp9
- DEB Ver :
1.4.0
- DEB Deps: Nil
Details
23 - chkpass
data type for auto-encrypted passwords
Overview
PIGSTY 3rd Party Extension: chkpass
: data type for auto-encrypted passwords
- Version: 1.0
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
chkpass_$v*
- RPM Ver :
1.0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-chkpass
- DEB Ver :
1.0
- DEB Deps: Nil
Details
24 - isn
data types for international product numbering standards
Overview
CONTRIB Built-in Extension: isn
: data types for international product numbering standards
- Version: 1.2
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Trusted, Can be created by user with
CREATE
Privilege
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
25 - seg
data type for representing line segments or floating-point intervals
Overview
CONTRIB Built-in Extension: seg
: data type for representing line segments or floating-point intervals
- Version: 1.4
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Trusted, Can be created by user with
CREATE
Privilege
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
26 - cube
data type for multidimensional cubes
Overview
CONTRIB Built-in Extension: cube
: data type for multidimensional cubes
- Version: 1.5
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
27 - ltree
data type for hierarchical tree-like structures
Overview
CONTRIB Built-in Extension: ltree
: data type for hierarchical tree-like structures
- Version: 1.2
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Trusted, Can be created by user with
CREATE
Privilege
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
28 - hstore
data type for storing sets of (key, value) pairs
Overview
CONTRIB Built-in Extension: hstore
: data type for storing sets of (key, value) pairs
- Version: 1.8
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Trusted, Can be created by user with
CREATE
Privilege
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
29 - citext
data type for case-insensitive character strings
Overview
CONTRIB Built-in Extension: citext
: data type for case-insensitive character strings
- Version: 1.6
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Trusted, Can be created by user with
CREATE
Privilege
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
30 - xml2
XPath querying and XSLT
Overview
CONTRIB Built-in Extension: xml2
: XPath querying and XSLT
- Version: 1.1
- PG Vers:
17
,16
,15
,14
,13
,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION
DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details