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 29 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
ip4r ip4r PGDG 2.4 TYPE PostgreSQL IPv4/v6 and IPv4/v6 range index type for PostgreSQL
uri pg_uri PIGSTY 1.20151224 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.1 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

1 - prefix

Prefix Range module for PostgreSQL

Overview

PGDG 1st Party Extension: prefix : Prefix Range module for PostgreSQL

Information

Metadata

  • Version: 1.2.0
  • PG Vers: 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

Information

Metadata

  • Version: 0.32.1
  • PG Vers: 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.32.1
  • DEB Deps: Nil

Details

3 - unit

SI units extension

Overview

PGDG 1st Party Extension: pgunit : SI units extension

Information

Metadata

  • Version: 7
  • PG Vers: 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

Information

Metadata

  • Version: 1.0.1
  • PG Vers: 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

Information

Metadata

  • Version: 1
  • PG Vers: 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

Information

Metadata

  • Version: 0.5
  • PG Vers: 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

Information

Metadata

  • Version: 0.2.0
  • PG Vers: 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

Information

Metadata

  • Version: 1.5.1
  • PG Vers: 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

Information

Metadata

  • Version: 0.0.3
  • PG Vers: 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

Information

Metadata

  • Version: 0.0.3
  • PG Vers: 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

Information

Metadata

  • Version: 1.1
  • PG Vers: 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

Information

Metadata

  • Version: 1
  • PG Vers: 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

Information

Metadata

  • Version: 0.0.2
  • PG Vers: 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

Information

Metadata

  • Version: 0
  • PG Vers: 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 - 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

Information

Metadata

  • Version: 2.4
  • PG Vers: 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

16 - uri

URI Data type for PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg_uri : URI Data type for PostgreSQL

Information

Metadata

  • Version: 1.20151224
  • PG Vers: 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.20151224
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-uri
  • DEB Ver : 1.20151224
  • DEB Deps: Nil

Details

17 - pgemailaddr

Email address type for PostgreSQL

Overview

PIGSTY 3rd Party Extension: pgemailaddr : Email address type for PostgreSQL

Information

Metadata

  • Version: 0
  • PG Vers: 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

18 - acl

ACL Data type

Overview

PIGSTY 3rd Party Extension: acl : ACL Data type

Information

Metadata

  • Version: 1.0.4
  • PG Vers: 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

19 - debversion

Debian version number data type

Overview

PGDG 1st Party Extension: debversion : Debian version number data type

Information

Metadata

  • Version: 1.1
  • PG Vers: 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.1
  • DEB Deps: Nil

Details

20 - pg_rrule

RRULE field type for PostgreSQL

Overview

PGDG 1st Party Extension: pg_rrule : RRULE field type for PostgreSQL

Information

Metadata

  • Version: 0.2.0
  • PG Vers: 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

21 - timestamp9

timestamp nanosecond resolution

Overview

PGDG 1st Party Extension: timestamp9 : timestamp nanosecond resolution

Information

Metadata

  • Version: 1.4.0
  • PG Vers: 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: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

22 - chkpass

data type for auto-encrypted passwords

Overview

PIGSTY 3rd Party Extension: chkpass : data type for auto-encrypted passwords

Information

Metadata

  • Version: 1.0
  • PG Vers: 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

23 - isn

data types for international product numbering standards

Overview

CONTRIB Built-in Extension: isn : data types for international product numbering standards

Information

Metadata

  • Version: 1.2
  • PG Vers: 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

24 - 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

Information

Metadata

  • Version: 1.4
  • PG Vers: 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 - cube

data type for multidimensional cubes

Overview

CONTRIB Built-in Extension: cube : data type for multidimensional cubes

Information

Metadata

  • Version: 1.5
  • PG Vers: 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

26 - ltree

data type for hierarchical tree-like structures

Overview

CONTRIB Built-in Extension: ltree : data type for hierarchical tree-like structures

Information

Metadata

  • Version: 1.2
  • PG Vers: 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

27 - 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

Information

Metadata

  • Version: 1.8
  • PG Vers: 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 - citext

data type for case-insensitive character strings

Overview

CONTRIB Built-in Extension: citext : data type for case-insensitive character strings

Information

Metadata

  • Version: 1.6
  • PG Vers: 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 - xml2

XPath querying and XSLT

Overview

CONTRIB Built-in Extension: xml2 : XPath querying and XSLT

Information

Metadata

  • Version: 1.1
  • PG Vers: 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