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

1 - prefix

Prefix Range module for PostgreSQL

Overview

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

Information

Metadata

  • Latest Version: 1.2.0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PGDG
  • RPM Name: prefix_$v*
  • RPM Ver : 1.2.0
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-prefix
  • DEB Ver : 1.2.0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 prefix_17
PGDG 1.2.10
prefix_16
PGDG 1.2.10
prefix_15
PGDG 1.2.9
prefix_14
PGDG 1.2.9
prefix_13
PGDG 1.2.10
el8 aarch64 prefix_17
PGDG 1.2.10
prefix_16
PGDG 1.2.10
prefix_15
PGDG 1.2.9
prefix_14
PGDG 1.2.9
prefix_13
PGDG 1.2.9
el9 x86_64 prefix_17
PGDG 1.2.10
prefix_16
PGDG 1.2.10
prefix_15
PGDG 1.2.9
prefix_14
PGDG 1.2.10
prefix_13
PGDG 1.2.10
el9 aarch64 prefix_17
PGDG 1.2.10
prefix_16
PGDG 1.2.10
prefix_15
PGDG 1.2.9
prefix_14
PGDG 1.2.9
prefix_13
PGDG 1.2.9
d12 x86_64 postgresql-17-prefix
PGDG 1.2.10
postgresql-16-prefix
PGDG 1.2.10
postgresql-15-prefix
PGDG 1.2.10
postgresql-14-prefix
PGDG 1.2.10
postgresql-13-prefix
PGDG 1.2.10
d12 aarch64 postgresql-17-prefix
PGDG 1.2.10
postgresql-16-prefix
PGDG 1.2.10
postgresql-15-prefix
PGDG 1.2.10
postgresql-14-prefix
PGDG 1.2.10
postgresql-13-prefix
PGDG 1.2.10
u22 x86_64 postgresql-17-prefix
PGDG 1.2.10
postgresql-16-prefix
PGDG 1.2.10
postgresql-15-prefix
PGDG 1.2.10
postgresql-14-prefix
PGDG 1.2.10
postgresql-13-prefix
PGDG 1.2.10
u22 aarch64 postgresql-17-prefix
PGDG 1.2.10
postgresql-16-prefix
PGDG 1.2.10
postgresql-15-prefix
PGDG 1.2.10
postgresql-14-prefix
PGDG 1.2.10
postgresql-13-prefix
PGDG 1.2.10
u24 x86_64 postgresql-17-prefix
PGDG 1.2.10
postgresql-16-prefix
PGDG 1.2.10
postgresql-15-prefix
PGDG 1.2.10
postgresql-14-prefix
PGDG 1.2.10
postgresql-13-prefix
PGDG 1.2.10
u24 aarch64 postgresql-17-prefix
PGDG 1.2.10
postgresql-16-prefix
PGDG 1.2.10
postgresql-15-prefix
PGDG 1.2.10
postgresql-14-prefix
PGDG 1.2.10
postgresql-13-prefix
PGDG 1.2.10

Installation

Install prefix via the pig CLI tool:


pig ext install pg_prefix; # Extension Namepig ext install prefix; # normalized package name

Install pg_prefix via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_prefix"]}' # -l <cls>

Install pg_prefix RPM from YUM repo directly:

dnf install prefix_17*;
dnf install prefix_16*;
dnf install prefix_15*;
dnf install prefix_14*;
dnf install prefix_13*;

Install pg_prefix DEB from APT repo directly:

apt install postgresql-17-prefix;
apt install postgresql-16-prefix;
apt install postgresql-15-prefix;
apt install postgresql-14-prefix;
apt install postgresql-13-prefix;

Enable prefix extension on PostgreSQL cluster:

CREATE EXTENSION prefix;



2 - semver

Semantic version data type

Overview

PGDG 1st Party Extension: pg_semver : Semantic version data type

Information

Metadata

  • Latest Version: 0.32.1
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PGDG
  • RPM Name: semver_$v*
  • RPM Ver : 0.32.1
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-semver
  • DEB Ver : 0.40.0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 semver_17
PGDG 0.32.1
semver_16
PGDG 0.32.1
semver_15
PGDG 0.32.1
semver_14
PGDG 0.32.1
semver_13
PGDG 0.32.1
el8 aarch64 semver_17
PGDG 0.32.1
semver_16
PGDG 0.32.1
semver_15
PGDG 0.32.1
semver_14
PGDG 0.32.1
semver_13
PGDG 0.32.1
el9 x86_64 semver_17
PGDG 0.32.1
semver_16
PGDG 0.32.1
semver_15
PGDG 0.32.1
semver_14
PGDG 0.32.1
semver_13
PGDG 0.32.1
el9 aarch64 semver_17
PGDG 0.32.1
semver_16
PGDG 0.32.1
semver_15
PGDG 0.32.1
semver_14
PGDG 0.32.1
semver_13
PGDG 0.32.1
d12 x86_64 postgresql-17-semver
PGDG 0.40.0
postgresql-16-semver
PGDG 0.40.0
postgresql-15-semver
PGDG 0.40.0
postgresql-14-semver
PGDG 0.40.0
postgresql-13-semver
PGDG 0.40.0
d12 aarch64 postgresql-17-semver
PGDG 0.40.0
postgresql-16-semver
PGDG 0.40.0
postgresql-15-semver
PGDG 0.40.0
postgresql-14-semver
PGDG 0.40.0
postgresql-13-semver
PGDG 0.40.0
u22 x86_64 postgresql-17-semver
PGDG 0.40.0
postgresql-16-semver
PGDG 0.40.0
postgresql-15-semver
PGDG 0.40.0
postgresql-14-semver
PGDG 0.40.0
postgresql-13-semver
PGDG 0.40.0
u22 aarch64 postgresql-17-semver
PGDG 0.40.0
postgresql-16-semver
PGDG 0.40.0
postgresql-15-semver
PGDG 0.40.0
postgresql-14-semver
PGDG 0.40.0
postgresql-13-semver
PGDG 0.40.0
u24 x86_64 postgresql-17-semver
PGDG 0.40.0
postgresql-16-semver
PGDG 0.40.0
postgresql-15-semver
PGDG 0.40.0
postgresql-14-semver
PGDG 0.40.0
postgresql-13-semver
PGDG 0.40.0
u24 aarch64 postgresql-17-semver
PGDG 0.40.0
postgresql-16-semver
PGDG 0.40.0
postgresql-15-semver
PGDG 0.40.0
postgresql-14-semver
PGDG 0.40.0
postgresql-13-semver
PGDG 0.40.0

Installation

Install semver via the pig CLI tool:


pig ext install pg_semver; # Extension Namepig ext install semver; # normalized package name

Install pg_semver via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_semver"]}' # -l <cls>

Install pg_semver RPM from YUM repo directly:

dnf install semver_17*;
dnf install semver_16*;
dnf install semver_15*;
dnf install semver_14*;
dnf install semver_13*;

Install pg_semver DEB from APT repo directly:

apt install postgresql-17-semver;
apt install postgresql-16-semver;
apt install postgresql-15-semver;
apt install postgresql-14-semver;
apt install postgresql-13-semver;

Enable semver extension on PostgreSQL cluster:

CREATE EXTENSION semver;



3 - unit

SI units extension

Overview

PGDG 1st Party Extension: pgunit : SI units extension

Information

Metadata

  • Latest Version: 7
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can be installed into other schemas
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: plpgsql

RPM / DEB

  • RPM Repo: PGDG
  • RPM Name: postgresql-unit_$v*
  • RPM Ver : 7
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-unit
  • DEB Ver : 7
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 postgresql-unit_17
PGDG 7.9
postgresql-unit_16
PGDG 7.9
postgresql-unit_15
PGDG 7.9
postgresql-unit_14
PGDG 7.9
postgresql-unit_13
PGDG 7.9
el8 aarch64 postgresql-unit_17
PGDG 7.9
postgresql-unit_16
PGDG 7.9
postgresql-unit_15
PGDG 7.9
postgresql-unit_14
PGDG 7.9
postgresql-unit_13
PGDG 7.9
el9 x86_64 postgresql-unit_17
PGDG 7.9
postgresql-unit_16
PGDG 7.9
postgresql-unit_15
PGDG 7.9
postgresql-unit_14
PGDG 7.9
postgresql-unit_13
PGDG 7.9
el9 aarch64 postgresql-unit_17
PGDG 7.9
postgresql-unit_16
PGDG 7.9
postgresql-unit_15
PGDG 7.9
postgresql-unit_14
PGDG 7.9
postgresql-unit_13
PGDG 7.9
d12 x86_64 postgresql-17-unit
PGDG 7.10
postgresql-16-unit
PGDG 7.10
postgresql-15-unit
PGDG 7.10
postgresql-14-unit
PGDG 7.10
postgresql-13-unit
PGDG 7.10
d12 aarch64 postgresql-17-unit
PGDG 7.10
postgresql-16-unit
PGDG 7.10
postgresql-15-unit
PGDG 7.10
postgresql-14-unit
PGDG 7.10
postgresql-13-unit
PGDG 7.10
u22 x86_64 postgresql-17-unit
PGDG 7.10
postgresql-16-unit
PGDG 7.10
postgresql-15-unit
PGDG 7.10
postgresql-14-unit
PGDG 7.10
postgresql-13-unit
PGDG 7.10
u22 aarch64 postgresql-17-unit
PGDG 7.10
postgresql-16-unit
PGDG 7.10
postgresql-15-unit
PGDG 7.10
postgresql-14-unit
PGDG 7.10
postgresql-13-unit
PGDG 7.10
u24 x86_64 postgresql-17-unit
PGDG 7.10
postgresql-16-unit
PGDG 7.10
postgresql-15-unit
PGDG 7.10
postgresql-14-unit
PGDG 7.10
postgresql-13-unit
PGDG 7.10
u24 aarch64 postgresql-17-unit
PGDG 7.10
postgresql-16-unit
PGDG 7.10
postgresql-15-unit
PGDG 7.10
postgresql-14-unit
PGDG 7.10
postgresql-13-unit
PGDG 7.10

Installation

Install unit via the pig CLI tool:


pig ext install pgunit; # Extension Namepig ext install unit; # normalized package name

Install pgunit via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgunit"]}' # -l <cls>

Install pgunit RPM from YUM repo directly:

dnf install postgresql-unit_17*;
dnf install postgresql-unit_16*;
dnf install postgresql-unit_15*;
dnf install postgresql-unit_14*;
dnf install postgresql-unit_13*;

Install pgunit DEB from APT repo directly:

apt install postgresql-17-unit;
apt install postgresql-16-unit;
apt install postgresql-15-unit;
apt install postgresql-14-unit;
apt install postgresql-13-unit;

Enable unit extension on PostgreSQL cluster:

CREATE EXTENSION unit CASCADE;



4 - pgpdf

PDF type with meta admin & Full-Text Search

Overview

PIGSTY 3rd Party Extension: pgpdf : PDF type with meta admin & Full-Text Search

Information

Metadata

  • Latest Version: 0.1.0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Explicit Loading Required
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pgpdf_$v*
  • RPM Ver : 0.1.0
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pgpdf
  • DEB Ver : 0.1.0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pgpdf_17
PIGSTY 0.1.0
pgpdf_16
PIGSTY 0.1.0
pgpdf_15
PIGSTY 0.1.0
pgpdf_14
PIGSTY 0.1.0
pgpdf_13
PIGSTY 0.1.0
el8 aarch64 pgpdf_17
PIGSTY 0.1.0
pgpdf_16
PIGSTY 0.1.0
pgpdf_15
PIGSTY 0.1.0
pgpdf_14
PIGSTY 0.1.0
pgpdf_13
PIGSTY 0.1.0
el9 x86_64 pgpdf_17
PIGSTY 0.1.0
pgpdf_16
PIGSTY 0.1.0
pgpdf_15
PIGSTY 0.1.0
pgpdf_14
PIGSTY 0.1.0
pgpdf_13
PIGSTY 0.1.0
el9 aarch64 pgpdf_17
PIGSTY 0.1.0
pgpdf_16
PIGSTY 0.1.0
pgpdf_15
PIGSTY 0.1.0
pgpdf_14
PIGSTY 0.1.0
pgpdf_13
PIGSTY 0.1.0
d12 x86_64 postgresql-17-pgpdf
PIGSTY 0.1.0
postgresql-16-pgpdf
PIGSTY 0.1.0
postgresql-15-pgpdf
PIGSTY 0.1.0
postgresql-14-pgpdf
PIGSTY 0.1.0
postgresql-13-pgpdf
PIGSTY 0.1.0
d12 aarch64 postgresql-17-pgpdf
PIGSTY 0.1.0
postgresql-16-pgpdf
PIGSTY 0.1.0
postgresql-15-pgpdf
PIGSTY 0.1.0
postgresql-14-pgpdf
PIGSTY 0.1.0
postgresql-13-pgpdf
PIGSTY 0.1.0
u22 x86_64 postgresql-17-pgpdf
PIGSTY 0.1.0
postgresql-16-pgpdf
PIGSTY 0.1.0
postgresql-15-pgpdf
PIGSTY 0.1.0
postgresql-14-pgpdf
PIGSTY 0.1.0
postgresql-13-pgpdf
PIGSTY 0.1.0
u22 aarch64 postgresql-17-pgpdf
PIGSTY 0.1.0
postgresql-16-pgpdf
PIGSTY 0.1.0
postgresql-15-pgpdf
PIGSTY 0.1.0
postgresql-14-pgpdf
PIGSTY 0.1.0
postgresql-13-pgpdf
PIGSTY 0.1.0
u24 x86_64 postgresql-17-pgpdf
PIGSTY 0.1.0
postgresql-16-pgpdf
PIGSTY 0.1.0
postgresql-15-pgpdf
PIGSTY 0.1.0
postgresql-14-pgpdf
PIGSTY 0.1.0
postgresql-13-pgpdf
PIGSTY 0.1.0
u24 aarch64 postgresql-17-pgpdf
PIGSTY 0.1.0
postgresql-16-pgpdf
PIGSTY 0.1.0
postgresql-15-pgpdf
PIGSTY 0.1.0
postgresql-14-pgpdf
PIGSTY 0.1.0
postgresql-13-pgpdf
PIGSTY 0.1.0

Installation

Install pgpdf via the pig CLI tool:

pig ext install pgpdf

Install pgpdf via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgpdf"]}' # -l <cls>

Install pgpdf RPM from YUM repo directly:

dnf install pgpdf_17*;
dnf install pgpdf_16*;
dnf install pgpdf_15*;
dnf install pgpdf_14*;
dnf install pgpdf_13*;

Install pgpdf DEB from APT repo directly:

apt install postgresql-17-pgpdf;
apt install postgresql-16-pgpdf;
apt install postgresql-15-pgpdf;
apt install postgresql-14-pgpdf;
apt install postgresql-13-pgpdf;

Extension pgpdf has to be added to shared_preload_libraries

shared_preload_libraries = 'pgpdf'; # add to pg cluster config

Enable pgpdf extension on PostgreSQL cluster:

CREATE EXTENSION pgpdf;

Usage

The actual PDF parsing is done by poppler.

This allows you to work with PDFs in an ACID-compliant way. The usual alternative relies on external scripts or services which can easily make your data ingestion pipeline brittle and leave your raw data out-of-sync.

Download some PDFs.

wget https://wiki.postgresql.org/images/e/ea/PostgreSQL_Introduction.pdf -O /tmp/pgintro.pdf
wget https://pdfobject.com/pdf/sample.pdf -O /tmp/sample.pdf

You can create a pdf type, by casting either a text filepath or bytea column.

CREATE EXTENSION pgpdf;
SELECT '/tmp/pgintro.pdf'::pdf;
                                       pdf                                        
----------------------------------------------------------------------------------
 PostgreSQL Introduction                                                         +
 Digoal.Zhou                                                                     +
 7/20/2011Catalog                                                                +
  PostgreSQL Origin 

If you don’t have the PDF file in your filesystem, but have already stored its content in a bytea column, you can just cast it to pdf.

SELECT pg_read_binary_file('/tmp/pgintro.pdf')::bytea::pdf;

Examples

Create a table with a pdf column:

CREATE TABLE pdfs(name text primary key, doc pdf);

INSERT INTO pdfs VALUES ('pgintro', '/tmp/pgintro.pdf');
INSERT INTO pdfs VALUES ('pgintro', '/tmp/sample.pdf');

Parsing and validation should happen automatically. The files will be read from the disk only once!

[!NOTE] The filepath should be accessible by the postgres process / user! That’s different than the user running psql. If you don’t understand what this means, as your DBA!

String Functions and Operators

Standard Postgres String Functions and Operators should work as usual:

SELECT 'Below is the PDF we received ' || '/tmp/pgintro.pdf'::pdf;
SELECT upper('/tmp/pgintro.pdf'::pdf::text);
SELECT name
FROM pdfs
WHERE doc::text LIKE '%Postgres%';

Full-Text Search (FTS)

You can also perform full-text search (FTS), since you can work on a pdf file like normal text.

SELECT '/tmp/pgintro.pdf'::pdf::text @@ to_tsquery('postgres');
 ?column? 
----------
 t
(1 row)
SELECT '/tmp/pgintro.pdf'::pdf::text @@ to_tsquery('oracle');
 ?column? 
----------
 f
(1 row)

Document similarity with pg_trgm

You can use pg_trgm to get the similarity between two documents:

CREATE EXTENSION pg_trgm;

SELECT similarity('/tmp/pgintro.pdf'::pdf::text, '/tmp/sample.pdf'::pdf::text);

Metadata

The following functions are available:

  • pdf_title(pdf) → text

  • pdf_author(pdf) → text

  • pdf_num_pages(pdf) → integer

    Total number of pages in the document

  • pdf_page(pdf, integer) → text

    Get the i-th page as text

  • pdf_creator(pdf) → text

  • pdf_keywords(pdf) → text

  • pdf_metadata(pdf) → text

  • pdf_version(pdf) → text

  • pdf_subject(pdf) → text

  • pdf_creation(pdf) → timestamp

  • pdf_modification(pdf) → timestamp

SELECT pdf_title('/tmp/pgintro.pdf');
        pdf_title        
-------------------------
 PostgreSQL Introduction
(1 row)
SELECT pdf_author('/tmp/pgintro.pdf');
 pdf_author 
------------
 周正中
(1 row)

Getting a subset of pages

SELECT pdf_num_pages('/tmp/pgintro.pdf');
 pdf_num_pages 
---------------
            24
(1 row)
SELECT pdf_page('/tmp/pgintro.pdf', 1);
           pdf_page           
------------------------------
 Catalog                     +
  PostgreSQL Origin         +
  Layout                    +
  Features                  +
  Enterprise Class Attribute+
  Case
(1 row)
SELECT pdf_subject('/tmp/pgintro.pdf');
 pdf_subject 
-------------
 
(1 row)
SELECT pdf_creation('/tmp/pgintro.pdf');
       pdf_creation       
--------------------------
 Wed Jul 20 11:13:37 2011
(1 row)
SELECT pdf_modification('/tmp/pgintro.pdf');
     pdf_modification     
--------------------------
 Wed Jul 20 11:13:37 2011
(1 row)
SELECT pdf_creator('/tmp/pgintro.pdf');
            pdf_creator             
------------------------------------
 Microsoft® Office PowerPoint® 2007
(1 row)
SELECT pdf_metadata('/tmp/pgintro.pdf');
 pdf_metadata 
--------------
 
(1 row)
SELECT pdf_version('/tmp/pgintro.pdf');
 pdf_version 
-------------
 PDF-1.5
(1 row)

Installation

Install poppler dependencies

Linux

sudo apt install -y libpoppler-glib-dev pkg-config

Homebrew/MacOS

brew install poppler pkgconf
cd /tmp
git clone https://github.com/Florents-Tselai/pgpdf.git
cd pgpdf
make
make install # may need sudo

After the installation, in a session:

CREATE EXTENSION pgpdf;

Docker

Get the Docker image with:

docker pull florents/pgpdf:pg17

This adds pgpdf to the Postgres image (replace 17 with your Postgres server version, and run it the same way).

Run the image in a container.

docker run --name pgpdf -p 5432:5432 -e POSTGRES_PASSWORD=pass florents/pgpdf:pg17

Through another terminal, connect to the running server (container).

PGPASSWORD=pass psql -h localhost -p 5432 -U postgres

[!WARNING] Reading arbitrary binary data (PDF) into your database can pose security risks. Only use this for files you trust.




5 - pglite_fusion

Embed an SQLite database in your PostgreSQL table

Overview

PIGSTY 3rd Party Extension: pglite_fusion : Embed an SQLite database in your PostgreSQL table

Information

Metadata

  • Latest Version: 0.0.3
  • Postgres Support: 17,16,15,14,13
  • Need Load: Explicit Loading Required
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can be installed into other schemas
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pglite_fusion_$v
  • RPM Ver : 0.0.3
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pglite-fusion
  • DEB Ver : 0.0.3
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pglite_fusion_17
PIGSTY 0.0.3
pglite_fusion_16
PIGSTY 0.0.3
pglite_fusion_15
PIGSTY 0.0.3
pglite_fusion_14
PIGSTY 0.0.3
pglite_fusion_13
PIGSTY 0.0.3
el8 aarch64 pglite_fusion_17
PIGSTY 0.0.3
pglite_fusion_16
PIGSTY 0.0.3
pglite_fusion_15
PIGSTY 0.0.3
pglite_fusion_14
PIGSTY 0.0.3
pglite_fusion_13
PIGSTY 0.0.3
el9 x86_64 pglite_fusion_17
PIGSTY 0.0.3
pglite_fusion_16
PIGSTY 0.0.3
pglite_fusion_15
PIGSTY 0.0.3
pglite_fusion_14
PIGSTY 0.0.3
pglite_fusion_13
PIGSTY 0.0.3
el9 aarch64 pglite_fusion_17
PIGSTY 0.0.3
pglite_fusion_16
PIGSTY 0.0.3
pglite_fusion_15
PIGSTY 0.0.3
pglite_fusion_14
PIGSTY 0.0.3
pglite_fusion_13
PIGSTY 0.0.3
d12 x86_64 postgresql-17-pglite-fusion
PIGSTY 0.0.3
postgresql-16-pglite-fusion
PIGSTY 0.0.3
postgresql-15-pglite-fusion
PIGSTY 0.0.3
postgresql-14-pglite-fusion
PIGSTY 0.0.3
postgresql-13-pglite-fusion
PIGSTY 0.0.3
d12 aarch64 postgresql-17-pglite-fusion
PIGSTY 0.0.3
postgresql-16-pglite-fusion
PIGSTY 0.0.3
postgresql-15-pglite-fusion
PIGSTY 0.0.3
postgresql-14-pglite-fusion
PIGSTY 0.0.3
postgresql-13-pglite-fusion
PIGSTY 0.0.3
u22 x86_64 postgresql-17-pglite-fusion
PIGSTY 0.0.3
postgresql-16-pglite-fusion
PIGSTY 0.0.3
postgresql-15-pglite-fusion
PIGSTY 0.0.3
postgresql-14-pglite-fusion
PIGSTY 0.0.3
postgresql-13-pglite-fusion
PIGSTY 0.0.3
u22 aarch64 postgresql-17-pglite-fusion
PIGSTY 0.0.3
postgresql-16-pglite-fusion
PIGSTY 0.0.3
postgresql-15-pglite-fusion
PIGSTY 0.0.3
postgresql-14-pglite-fusion
PIGSTY 0.0.3
postgresql-13-pglite-fusion
PIGSTY 0.0.3
u24 x86_64 postgresql-17-pglite-fusion
PIGSTY 0.0.3
postgresql-16-pglite-fusion
PIGSTY 0.0.3
postgresql-15-pglite-fusion
PIGSTY 0.0.3
postgresql-14-pglite-fusion
PIGSTY 0.0.3
postgresql-13-pglite-fusion
PIGSTY 0.0.3
u24 aarch64 postgresql-17-pglite-fusion
PIGSTY 0.0.3
postgresql-16-pglite-fusion
PIGSTY 0.0.3
postgresql-15-pglite-fusion
PIGSTY 0.0.3
postgresql-14-pglite-fusion
PIGSTY 0.0.3
postgresql-13-pglite-fusion
PIGSTY 0.0.3

Installation

Install pglite_fusion via the pig CLI tool:

pig ext install pglite_fusion

Install pglite_fusion via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pglite_fusion"]}' # -l <cls>

Install pglite_fusion RPM from YUM repo directly:

dnf install pglite_fusion_17;
dnf install pglite_fusion_16;
dnf install pglite_fusion_15;
dnf install pglite_fusion_14;
dnf install pglite_fusion_13;

Install pglite_fusion DEB from APT repo directly:

apt install postgresql-17-pglite-fusion;
apt install postgresql-16-pglite-fusion;
apt install postgresql-15-pglite-fusion;
apt install postgresql-14-pglite-fusion;
apt install postgresql-13-pglite-fusion;

Extension pglite_fusion has to be added to shared_preload_libraries

shared_preload_libraries = 'pglite_fusion'; # add to pg cluster config

Enable pglite_fusion extension on PostgreSQL cluster:

CREATE EXTENSION pglite_fusion;

Usage

https://github.com/frectonz/pglite-fusion/blob/main/README.md

Here’s some demo usage.

-- Load PG extension
CREATE EXTENSION pglite_fusion;

-- Create a table with an SQLite column
CREATE TABLE people (
                        name     TEXT NOT NULL,
                        database SQLITE DEFAULT init_sqlite('CREATE TABLE todos (task TEXT)')
);

-- Insert a row into the people table
INSERT INTO people VALUES ('frectonz');

-- Create a todo for "frectonz"
UPDATE people
SET database = execute_sqlite(
        database,
        'INSERT INTO todos VALUES (''solve multitenancy'')'
               )
WHERE name = 'frectonz';

-- Create a todo for "frectonz"
UPDATE people
SET database = execute_sqlite(
        database,
        'INSERT INTO todos VALUES (''buy milk'')'
               )
WHERE name = 'frectonz';

-- Fetch frectonz's info
SELECT
    name,
    (
        SELECT json_agg(get_sqlite_text(sqlite_row, 0))
        FROM query_sqlite(
                database,
                'SELECT * FROM todos'
             )
    ) AS todos
FROM
    people
WHERE
    name = 'frectonz';

API Doc

empty_sqlite

Creates an empty SQLite database and returns it as a binary object. This can be used to initialize an empty SQLite database in a PostgreSQL column.

Example Usage:

SELECT empty_sqlite();

query_sqlite

Executes a SQL query on a SQLite database stored as a binary object and returns the result as a table of JSON-encoded rows. This function is useful for querying SQLite databases stored in PostgreSQL columns.

Parameters:

  • sqlite: The SQLite database to query, stored as a binary object.
  • query: The SQL query string to execute on the SQLite database.

Example Usage:

SELECT * FROM query_sqlite(
        database,
        'SELECT * FROM todos'
              );

execute_sqlite

Executes a SQL statement (such as INSERT, UPDATE, or DELETE) on a SQLite database stored as a binary object. The updated SQLite database is returned as a binary object, allowing further operations on it.

Parameters:

  • sqlite: The SQLite database to execute the SQL query on, stored as a binary object.
  • query: The SQL statement to execute on the SQLite database.
Example Usage:
UPDATE people
SET database = execute_sqlite(
        database,
        'INSERT INTO todos VALUES (''solve multitenancy'')'
               )
WHERE name = 'frectonz';

init_sqlite

Creates an SQLite database with an initialization query already applied on it. This can be used to initialize a SQLite database with the expected tables already created.

Parameters:

  • query: The SQL statement to execute on the SQLite database.
Example Usage:

CREATE TABLE people (
                        name     TEXT NOT NULL,
                        database SQLITE DEFAULT init_sqlite('CREATE TABLE todos (task TEXT)')
);

get_sqlite_text

Extracts a text value from a specific column in a row returned by query_sqlite. Use this function to retrieve text values from query results.

Parameters:

  • sqlite_row: A row from the results of query_sqlite.
  • index: The index of the column to extract from the row.

Example Usage:

SELECT get_sqlite_text(sqlite_row, 0)
FROM query_sqlite(database, 'SELECT * FROM todos');

get_sqlite_integer

Extracts an integer value from a specific column in a row returned by query_sqlite. Use this function to retrieve integer values from query results.

Parameters:

  • sqlite_row: A row from the results of query_sqlite.
  • index: The index of the column to extract from the row.

Example Usage:

SELECT get_sqlite_integer(sqlite_row, 1)
FROM query_sqlite(database, 'SELECT * FROM todos');

get_sqlite_real

Extracts a real (floating-point) value from a specific column in a row returned by query_sqlite. Use this function to retrieve real number values from query results.

Parameters:

  • sqlite_row: A row from the results of query_sqlite.
  • index: The index of the column to extract from the row.

Example Usage:

SELECT get_sqlite_real(sqlite_row, 2)
FROM query_sqlite(database, 'SELECT * FROM todos');



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

  • Latest Version: 1.0.1
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: md5hash_$v*
  • RPM Ver : 1.0.1
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-md5hash
  • DEB Ver : 1.0.1
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 md5hash_17
PIGSTY 1.0.1
md5hash_16
PIGSTY 1.0.1
md5hash_15
PIGSTY 1.0.1
md5hash_14
PIGSTY 1.0.1
md5hash_13
PIGSTY 1.0.1
el8 aarch64 md5hash_17
PIGSTY 1.0.1
md5hash_16
PIGSTY 1.0.1
md5hash_15
PIGSTY 1.0.1
md5hash_14
PIGSTY 1.0.1
md5hash_13
PIGSTY 1.0.1
el9 x86_64 md5hash_17
PIGSTY 1.0.1
md5hash_16
PIGSTY 1.0.1
md5hash_15
PIGSTY 1.0.1
md5hash_14
PIGSTY 1.0.1
md5hash_13
PIGSTY 1.0.1
el9 aarch64 md5hash_17
PIGSTY 1.0.1
md5hash_16
PIGSTY 1.0.1
md5hash_15
PIGSTY 1.0.1
md5hash_14
PIGSTY 1.0.1
md5hash_13
PIGSTY 1.0.1
d12 x86_64 postgresql-17-md5hash
PIGSTY 1.0.1
postgresql-16-md5hash
PIGSTY 1.0.1
postgresql-15-md5hash
PIGSTY 1.0.1
postgresql-14-md5hash
PIGSTY 1.0.1
postgresql-13-md5hash
PIGSTY 1.0.1
d12 aarch64 postgresql-17-md5hash
PIGSTY 1.0.1
postgresql-16-md5hash
PIGSTY 1.0.1
postgresql-15-md5hash
PIGSTY 1.0.1
postgresql-14-md5hash
PIGSTY 1.0.1
postgresql-13-md5hash
PIGSTY 1.0.1
u22 x86_64 postgresql-17-md5hash
PIGSTY 1.0.1
postgresql-16-md5hash
PIGSTY 1.0.1
postgresql-15-md5hash
PIGSTY 1.0.1
postgresql-14-md5hash
PIGSTY 1.0.1
postgresql-13-md5hash
PIGSTY 1.0.1
u22 aarch64 postgresql-17-md5hash
PIGSTY 1.0.1
postgresql-16-md5hash
PIGSTY 1.0.1
postgresql-15-md5hash
PIGSTY 1.0.1
postgresql-14-md5hash
PIGSTY 1.0.1
postgresql-13-md5hash
PIGSTY 1.0.1
u24 x86_64 postgresql-17-md5hash
PIGSTY 1.0.1
postgresql-16-md5hash
PIGSTY 1.0.1
postgresql-15-md5hash
PIGSTY 1.0.1
postgresql-14-md5hash
PIGSTY 1.0.1
postgresql-13-md5hash
PIGSTY 1.0.1
u24 aarch64 postgresql-17-md5hash
PIGSTY 1.0.1
postgresql-16-md5hash
PIGSTY 1.0.1
postgresql-15-md5hash
PIGSTY 1.0.1
postgresql-14-md5hash
PIGSTY 1.0.1
postgresql-13-md5hash
PIGSTY 1.0.1

Installation

Install md5hash via the pig CLI tool:

pig ext install md5hash

Install md5hash via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["md5hash"]}' # -l <cls>

Install md5hash RPM from YUM repo directly:

dnf install md5hash_17*;
dnf install md5hash_16*;
dnf install md5hash_15*;
dnf install md5hash_14*;
dnf install md5hash_13*;

Install md5hash DEB from APT repo directly:

apt install postgresql-17-md5hash;
apt install postgresql-16-md5hash;
apt install postgresql-15-md5hash;
apt install postgresql-14-md5hash;
apt install postgresql-13-md5hash;

Enable md5hash extension on PostgreSQL cluster:

CREATE EXTENSION md5hash;



7 - asn1oid

asn1oid extension

Overview

MIXED 3rd Party Extension: asn1oid : asn1oid extension

Information

Metadata

  • Latest Version: 1
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: asn1oid_$v*
  • RPM Ver : 1
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-asn1oid
  • DEB Ver : 1
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 asn1oid_17
PIGSTY 1.5
asn1oid_16
PIGSTY 1.5
asn1oid_15
PIGSTY 1.5
asn1oid_14
PIGSTY 1.5
asn1oid_13
PIGSTY 1.5
el8 aarch64 asn1oid_17
PIGSTY 1.5
asn1oid_16
PIGSTY 1.5
asn1oid_15
PIGSTY 1.5
asn1oid_14
PIGSTY 1.5
asn1oid_13
PIGSTY 1.5
el9 x86_64 asn1oid_17
PIGSTY 1.5
asn1oid_16
PIGSTY 1.5
asn1oid_15
PIGSTY 1.5
asn1oid_14
PIGSTY 1.5
asn1oid_13
PIGSTY 1.5
el9 aarch64 asn1oid_17
PIGSTY 1.5
asn1oid_16
PIGSTY 1.5
asn1oid_15
PIGSTY 1.5
asn1oid_14
PIGSTY 1.5
asn1oid_13
PIGSTY 1.5
d12 x86_64 postgresql-17-asn1oid
PGDG 1.6
postgresql-16-asn1oid
PGDG 1.6
postgresql-15-asn1oid
PGDG 1.6
postgresql-14-asn1oid
PGDG 1.6
postgresql-13-asn1oid
PGDG 1.6
d12 aarch64 postgresql-17-asn1oid
PGDG 1.6
postgresql-16-asn1oid
PGDG 1.6
postgresql-15-asn1oid
PGDG 1.6
postgresql-14-asn1oid
PGDG 1.6
postgresql-13-asn1oid
PGDG 1.6
u22 x86_64 postgresql-17-asn1oid
PGDG 1.6
postgresql-16-asn1oid
PGDG 1.6
postgresql-15-asn1oid
PGDG 1.6
postgresql-14-asn1oid
PGDG 1.6
postgresql-13-asn1oid
PGDG 1.6
u22 aarch64 postgresql-17-asn1oid
PGDG 1.6
postgresql-16-asn1oid
PGDG 1.6
postgresql-15-asn1oid
PGDG 1.6
postgresql-14-asn1oid
PGDG 1.6
postgresql-13-asn1oid
PGDG 1.6
u24 x86_64 postgresql-17-asn1oid
PGDG 1.6
postgresql-16-asn1oid
PGDG 1.6
postgresql-15-asn1oid
PGDG 1.6
postgresql-14-asn1oid
PGDG 1.6
postgresql-13-asn1oid
PGDG 1.6
u24 aarch64 postgresql-17-asn1oid
PGDG 1.6
postgresql-16-asn1oid
PGDG 1.6
postgresql-15-asn1oid
PGDG 1.6
postgresql-14-asn1oid
PGDG 1.6
postgresql-13-asn1oid
PGDG 1.6

Installation

Install asn1oid via the pig CLI tool:

pig ext install asn1oid

Install asn1oid via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["asn1oid"]}' # -l <cls>

Install asn1oid RPM from YUM repo directly:

dnf install asn1oid_17*;
dnf install asn1oid_16*;
dnf install asn1oid_15*;
dnf install asn1oid_14*;
dnf install asn1oid_13*;

Install asn1oid DEB from APT repo directly:

apt install postgresql-17-asn1oid;
apt install postgresql-16-asn1oid;
apt install postgresql-15-asn1oid;
apt install postgresql-14-asn1oid;
apt install postgresql-13-asn1oid;

Enable asn1oid extension on PostgreSQL cluster:

CREATE EXTENSION asn1oid;



8 - roaringbitmap

support for Roaring Bitmaps

Overview

MIXED 3rd Party Extension: roaringbitmap : support for Roaring Bitmaps

Information

Metadata

  • Latest Version: 0.5
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_roaringbitmap_$v*
  • RPM Ver : 0.5
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-roaringbitmap
  • DEB Ver : 0.5
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_roaringbitmap_17
PIGSTY 0.5.4
pg_roaringbitmap_16
PIGSTY 0.5.4
pg_roaringbitmap_15
PIGSTY 0.5.4
pg_roaringbitmap_14
PIGSTY 0.5.4
pg_roaringbitmap_13
PIGSTY 0.5.4
el8 aarch64 pg_roaringbitmap_17
PIGSTY 0.5.4
pg_roaringbitmap_16
PIGSTY 0.5.4
pg_roaringbitmap_15
PIGSTY 0.5.4
pg_roaringbitmap_14
PIGSTY 0.5.4
pg_roaringbitmap_13
PIGSTY 0.5.4
el9 x86_64 pg_roaringbitmap_17
PIGSTY 0.5.4
pg_roaringbitmap_16
PIGSTY 0.5.4
pg_roaringbitmap_15
PIGSTY 0.5.4
pg_roaringbitmap_14
PIGSTY 0.5.4
pg_roaringbitmap_13
PIGSTY 0.5.4
el9 aarch64 pg_roaringbitmap_17
PIGSTY 0.5.4
pg_roaringbitmap_16
PIGSTY 0.5.4
pg_roaringbitmap_15
PIGSTY 0.5.4
pg_roaringbitmap_14
PIGSTY 0.5.4
pg_roaringbitmap_13
PIGSTY 0.5.4
d12 x86_64 postgresql-17-roaringbitmap
PGDG 0.5.4
postgresql-16-roaringbitmap
PGDG 0.5.4
postgresql-15-roaringbitmap
PGDG 0.5.4
postgresql-14-roaringbitmap
PGDG 0.5.4
postgresql-13-roaringbitmap
PGDG 0.5.4
d12 aarch64 postgresql-17-roaringbitmap
PGDG 0.5.4
postgresql-16-roaringbitmap
PGDG 0.5.4
postgresql-15-roaringbitmap
PGDG 0.5.4
postgresql-14-roaringbitmap
PGDG 0.5.4
postgresql-13-roaringbitmap
PGDG 0.5.4
u22 x86_64 postgresql-17-roaringbitmap
PGDG 0.5.4
postgresql-16-roaringbitmap
PGDG 0.5.4
postgresql-15-roaringbitmap
PGDG 0.5.4
postgresql-14-roaringbitmap
PGDG 0.5.4
postgresql-13-roaringbitmap
PGDG 0.5.4
u22 aarch64 postgresql-17-roaringbitmap
PGDG 0.5.4
postgresql-16-roaringbitmap
PGDG 0.5.4
postgresql-15-roaringbitmap
PGDG 0.5.4
postgresql-14-roaringbitmap
PGDG 0.5.4
postgresql-13-roaringbitmap
PGDG 0.5.4
u24 x86_64 postgresql-17-roaringbitmap
PGDG 0.5.4
postgresql-16-roaringbitmap
PGDG 0.5.4
postgresql-15-roaringbitmap
PGDG 0.5.4
postgresql-14-roaringbitmap
PGDG 0.5.4
postgresql-13-roaringbitmap
PGDG 0.5.4
u24 aarch64 postgresql-17-roaringbitmap
PGDG 0.5.4
postgresql-16-roaringbitmap
PGDG 0.5.4
postgresql-15-roaringbitmap
PGDG 0.5.4
postgresql-14-roaringbitmap
PGDG 0.5.4
postgresql-13-roaringbitmap
PGDG 0.5.4

Installation

Install roaringbitmap via the pig CLI tool:

pig ext install roaringbitmap

Install roaringbitmap via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["roaringbitmap"]}' # -l <cls>

Install roaringbitmap RPM from YUM repo directly:

dnf install pg_roaringbitmap_17*;
dnf install pg_roaringbitmap_16*;
dnf install pg_roaringbitmap_15*;
dnf install pg_roaringbitmap_14*;
dnf install pg_roaringbitmap_13*;

Install roaringbitmap DEB from APT repo directly:

apt install postgresql-17-roaringbitmap;
apt install postgresql-16-roaringbitmap;
apt install postgresql-15-roaringbitmap;
apt install postgresql-14-roaringbitmap;
apt install postgresql-13-roaringbitmap;

Enable roaringbitmap extension on PostgreSQL cluster:

CREATE EXTENSION roaringbitmap;



9 - pgfaceting

fast faceting queries using an inverted index

Overview

MIXED 3rd Party Extension: pgfaceting : fast faceting queries using an inverted index

Information

Metadata

  • Latest Version: 0.2.0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can be installed into other schemas
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: faceting
  • Requires: roaringbitmap

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pgfaceting_$v
  • RPM Ver : 0.2.0
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgfaceting
  • DEB Ver : 0.2.0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pgfaceting_17
PIGSTY 0.2.0
pgfaceting_16
PIGSTY 0.2.0
pgfaceting_15
PIGSTY 0.2.0
pgfaceting_14
PIGSTY 0.2.0
pgfaceting_13
PIGSTY 0.2.0
el8 aarch64 pgfaceting_17
PIGSTY 0.2.0
pgfaceting_16
PIGSTY 0.2.0
pgfaceting_15
PIGSTY 0.2.0
pgfaceting_14
PIGSTY 0.2.0
pgfaceting_13
PIGSTY 0.2.0
el9 x86_64 pgfaceting_17
PIGSTY 0.2.0
pgfaceting_16
PIGSTY 0.2.0
pgfaceting_15
PIGSTY 0.2.0
pgfaceting_14
PIGSTY 0.2.0
pgfaceting_13
PIGSTY 0.2.0
el9 aarch64 pgfaceting_17
PIGSTY 0.2.0
pgfaceting_16
PIGSTY 0.2.0
pgfaceting_15
PIGSTY 0.2.0
pgfaceting_14
PIGSTY 0.2.0
pgfaceting_13
PIGSTY 0.2.0
d12 x86_64 postgresql-17-pgfaceting
PGDG 0.2.0
postgresql-16-pgfaceting
PGDG 0.2.0
postgresql-15-pgfaceting
PGDG 0.2.0
postgresql-14-pgfaceting
PGDG 0.2.0
d12 aarch64 postgresql-17-pgfaceting
PGDG 0.2.0
postgresql-16-pgfaceting
PGDG 0.2.0
postgresql-15-pgfaceting
PGDG 0.2.0
postgresql-14-pgfaceting
PGDG 0.2.0
u22 x86_64 postgresql-17-pgfaceting
PGDG 0.2.0
postgresql-16-pgfaceting
PGDG 0.2.0
postgresql-15-pgfaceting
PGDG 0.2.0
postgresql-14-pgfaceting
PGDG 0.2.0
u22 aarch64 postgresql-17-pgfaceting
PGDG 0.2.0
postgresql-16-pgfaceting
PGDG 0.2.0
postgresql-15-pgfaceting
PGDG 0.2.0
postgresql-14-pgfaceting
PGDG 0.2.0
u24 x86_64 postgresql-17-pgfaceting
PGDG 0.2.0
postgresql-16-pgfaceting
PGDG 0.2.0
postgresql-15-pgfaceting
PGDG 0.2.0
postgresql-14-pgfaceting
PGDG 0.2.0
u24 aarch64 postgresql-17-pgfaceting
PGDG 0.2.0
postgresql-16-pgfaceting
PGDG 0.2.0
postgresql-15-pgfaceting
PGDG 0.2.0
postgresql-14-pgfaceting
PGDG 0.2.0

Installation

Install pgfaceting via the pig CLI tool:

pig ext install pgfaceting

Install pgfaceting via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgfaceting"]}' # -l <cls>

Install pgfaceting RPM from YUM repo directly:

dnf install pgfaceting_17;
dnf install pgfaceting_16;
dnf install pgfaceting_15;
dnf install pgfaceting_14;
dnf install pgfaceting_13;

Install pgfaceting DEB from APT repo directly:

apt install postgresql-17-pgfaceting;
apt install postgresql-16-pgfaceting;
apt install postgresql-15-pgfaceting;
apt install postgresql-14-pgfaceting;

Enable pgfaceting extension on PostgreSQL cluster:

CREATE EXTENSION pgfaceting CASCADE;



10 - pg_sphere

spherical objects with useful functions, operators and index support

Overview

MIXED 3rd Party Extension: pgsphere : spherical objects with useful functions, operators and index support

Information

Metadata

  • Latest Version: 1.5.1
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pgsphere_$v*
  • RPM Ver : 1.5.1
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgsphere
  • DEB Ver : 1.5.1
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pgsphere_17
PIGSTY 1.5.1
pgsphere_16
PIGSTY 1.5.1
pgsphere_15
PIGSTY 1.5.1
pgsphere_14
PIGSTY 1.5.1
pgsphere_13
PIGSTY 1.5.1
el8 aarch64 pgsphere_17
PIGSTY 1.5.1
pgsphere_16
PIGSTY 1.5.1
pgsphere_15
PIGSTY 1.5.1
pgsphere_14
PIGSTY 1.5.1
pgsphere_13
PIGSTY 1.5.1
el9 x86_64 pgsphere_17
PIGSTY 1.5.1
pgsphere_16
PIGSTY 1.5.1
pgsphere_15
PIGSTY 1.5.1
pgsphere_14
PIGSTY 1.5.1
pgsphere_13
PIGSTY 1.5.1
el9 aarch64 pgsphere_17
PIGSTY 1.5.1
pgsphere_16
PIGSTY 1.5.1
pgsphere_15
PIGSTY 1.5.1
pgsphere_14
PIGSTY 1.5.1
pgsphere_13
PIGSTY 1.5.1
d12 x86_64 postgresql-17-pgsphere
PGDG 1.5.1
postgresql-16-pgsphere
PGDG 1.5.1
postgresql-15-pgsphere
PGDG 1.5.1
postgresql-14-pgsphere
PGDG 1.5.1
postgresql-13-pgsphere
PGDG 1.5.1
d12 aarch64 postgresql-17-pgsphere
PGDG 1.5.1
postgresql-16-pgsphere
PGDG 1.5.1
postgresql-15-pgsphere
PGDG 1.5.1
postgresql-14-pgsphere
PGDG 1.5.1
postgresql-13-pgsphere
PGDG 1.5.1
u22 x86_64 postgresql-17-pgsphere
PGDG 1.5.1
postgresql-16-pgsphere
PGDG 1.5.1
postgresql-15-pgsphere
PGDG 1.5.1
postgresql-14-pgsphere
PGDG 1.5.1
postgresql-13-pgsphere
PGDG 1.5.1
u22 aarch64 postgresql-17-pgsphere
PGDG 1.5.1
postgresql-16-pgsphere
PGDG 1.5.1
postgresql-15-pgsphere
PGDG 1.5.1
postgresql-14-pgsphere
PGDG 1.5.1
postgresql-13-pgsphere
PGDG 1.5.1
u24 x86_64 postgresql-17-pgsphere
PGDG 1.5.1
postgresql-16-pgsphere
PGDG 1.5.1
postgresql-15-pgsphere
PGDG 1.5.1
postgresql-14-pgsphere
PGDG 1.5.1
postgresql-13-pgsphere
PGDG 1.5.1
u24 aarch64 postgresql-17-pgsphere
PGDG 1.5.1
postgresql-16-pgsphere
PGDG 1.5.1
postgresql-15-pgsphere
PGDG 1.5.1
postgresql-14-pgsphere
PGDG 1.5.1
postgresql-13-pgsphere
PGDG 1.5.1

Installation

Install pg_sphere via the pig CLI tool:


pig ext install pgsphere; # Extension Namepig ext install pg_sphere; # normalized package name

Install pgsphere via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgsphere"]}' # -l <cls>

Install pgsphere RPM from YUM repo directly:

dnf install pgsphere_17*;
dnf install pgsphere_16*;
dnf install pgsphere_15*;
dnf install pgsphere_14*;
dnf install pgsphere_13*;

Install pgsphere DEB from APT repo directly:

apt install postgresql-17-pgsphere;
apt install postgresql-16-pgsphere;
apt install postgresql-15-pgsphere;
apt install postgresql-14-pgsphere;
apt install postgresql-13-pgsphere;

Enable pg_sphere extension on PostgreSQL cluster:

CREATE EXTENSION pg_sphere;



11 - country

Country data type, ISO 3166-1

Overview

PIGSTY 3rd Party Extension: pg_country : Country data type, ISO 3166-1

Information

Metadata

  • Latest Version: 0.0.3
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_country_$v*
  • RPM Ver : 0.0.3
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-country
  • DEB Ver : 0.0.3
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_country_17
PIGSTY 0.0.3
pg_country_16
PIGSTY 0.0.3
pg_country_15
PIGSTY 0.0.3
pg_country_14
PIGSTY 0.0.3
pg_country_13
PIGSTY 0.0.3
el8 aarch64 pg_country_17
PIGSTY 0.0.3
pg_country_16
PIGSTY 0.0.3
pg_country_15
PIGSTY 0.0.3
pg_country_14
PIGSTY 0.0.3
pg_country_13
PIGSTY 0.0.3
el9 x86_64 pg_country_17
PIGSTY 0.0.3
pg_country_16
PIGSTY 0.0.3
pg_country_15
PIGSTY 0.0.3
pg_country_14
PIGSTY 0.0.3
pg_country_13
PIGSTY 0.0.3
el9 aarch64 pg_country_17
PIGSTY 0.0.3
pg_country_16
PIGSTY 0.0.3
pg_country_15
PIGSTY 0.0.3
pg_country_14
PIGSTY 0.0.3
pg_country_13
PIGSTY 0.0.3
d12 x86_64 postgresql-17-pg-country
PIGSTY 0.0.3
postgresql-16-pg-country
PIGSTY 0.0.3
postgresql-15-pg-country
PIGSTY 0.0.3
postgresql-14-pg-country
PIGSTY 0.0.3
postgresql-13-pg-country
PIGSTY 0.0.3
d12 aarch64 postgresql-17-pg-country
PIGSTY 0.0.3
postgresql-16-pg-country
PIGSTY 0.0.3
postgresql-15-pg-country
PIGSTY 0.0.3
postgresql-14-pg-country
PIGSTY 0.0.3
postgresql-13-pg-country
PIGSTY 0.0.3
u22 x86_64 postgresql-17-pg-country
PIGSTY 0.0.3
postgresql-16-pg-country
PIGSTY 0.0.3
postgresql-15-pg-country
PIGSTY 0.0.3
postgresql-14-pg-country
PIGSTY 0.0.3
postgresql-13-pg-country
PIGSTY 0.0.3
u22 aarch64 postgresql-17-pg-country
PIGSTY 0.0.3
postgresql-16-pg-country
PIGSTY 0.0.3
postgresql-15-pg-country
PIGSTY 0.0.3
postgresql-14-pg-country
PIGSTY 0.0.3
postgresql-13-pg-country
PIGSTY 0.0.3
u24 x86_64 postgresql-17-pg-country
PIGSTY 0.0.3
postgresql-16-pg-country
PIGSTY 0.0.3
postgresql-15-pg-country
PIGSTY 0.0.3
postgresql-14-pg-country
PIGSTY 0.0.3
postgresql-13-pg-country
PIGSTY 0.0.3
u24 aarch64 postgresql-17-pg-country
PIGSTY 0.0.3
postgresql-16-pg-country
PIGSTY 0.0.3
postgresql-15-pg-country
PIGSTY 0.0.3
postgresql-14-pg-country
PIGSTY 0.0.3
postgresql-13-pg-country
PIGSTY 0.0.3

Installation

Install country via the pig CLI tool:


pig ext install pg_country; # Extension Namepig ext install country; # normalized package name

Install pg_country via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_country"]}' # -l <cls>

Install pg_country RPM from YUM repo directly:

dnf install pg_country_17*;
dnf install pg_country_16*;
dnf install pg_country_15*;
dnf install pg_country_14*;
dnf install pg_country_13*;

Install pg_country DEB from APT repo directly:

apt install postgresql-17-pg-country;
apt install postgresql-16-pg-country;
apt install postgresql-15-pg-country;
apt install postgresql-14-pg-country;
apt install postgresql-13-pg-country;

Enable country extension on PostgreSQL cluster:

CREATE EXTENSION country;



12 - pg_xenophile

More than the bare necessities for PostgreSQL i18n and l10n.

Overview

PIGSTY 3rd Party Extension: pg_xenophile : More than the bare necessities for PostgreSQL i18n and l10n.

Information

Metadata

  • Latest Version: 0.8.3
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can be installed into other schemas
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: xeno
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_xenophile_$v
  • RPM Ver : 0.8.3
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-xenophile
  • DEB Ver : 0.8.3
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_xenophile_17
PIGSTY 0.8.3
pg_xenophile_16
PIGSTY 0.8.3
pg_xenophile_15
PIGSTY 0.8.3
pg_xenophile_14
PIGSTY 0.8.3
pg_xenophile_13
PIGSTY 0.8.3
el8 aarch64 pg_xenophile_17
PIGSTY 0.8.3
pg_xenophile_16
PIGSTY 0.8.3
pg_xenophile_15
PIGSTY 0.8.3
pg_xenophile_14
PIGSTY 0.8.3
pg_xenophile_13
PIGSTY 0.8.3
el9 x86_64 pg_xenophile_17
PIGSTY 0.8.3
pg_xenophile_16
PIGSTY 0.8.3
pg_xenophile_15
PIGSTY 0.8.3
pg_xenophile_14
PIGSTY 0.8.3
pg_xenophile_13
PIGSTY 0.8.3
el9 aarch64 pg_xenophile_17
PIGSTY 0.8.3
pg_xenophile_16
PIGSTY 0.8.3
pg_xenophile_15
PIGSTY 0.8.3
pg_xenophile_14
PIGSTY 0.8.3
pg_xenophile_13
PIGSTY 0.8.3
d12 x86_64 postgresql-17-pg-xenophile
PIGSTY 0.8.3
postgresql-16-pg-xenophile
PIGSTY 0.8.3
postgresql-15-pg-xenophile
PIGSTY 0.8.3
postgresql-14-pg-xenophile
PIGSTY 0.8.3
postgresql-13-pg-xenophile
PIGSTY 0.8.3
d12 aarch64 postgresql-17-pg-xenophile
PIGSTY 0.8.3
postgresql-16-pg-xenophile
PIGSTY 0.8.3
postgresql-15-pg-xenophile
PIGSTY 0.8.3
postgresql-14-pg-xenophile
PIGSTY 0.8.3
postgresql-13-pg-xenophile
PIGSTY 0.8.3
u22 x86_64 postgresql-17-pg-xenophile
PIGSTY 0.8.3
postgresql-16-pg-xenophile
PIGSTY 0.8.3
postgresql-15-pg-xenophile
PIGSTY 0.8.3
postgresql-14-pg-xenophile
PIGSTY 0.8.3
postgresql-13-pg-xenophile
PIGSTY 0.8.3
u22 aarch64 postgresql-17-pg-xenophile
PIGSTY 0.8.3
postgresql-16-pg-xenophile
PIGSTY 0.8.3
postgresql-15-pg-xenophile
PIGSTY 0.8.3
postgresql-14-pg-xenophile
PIGSTY 0.8.3
postgresql-13-pg-xenophile
PIGSTY 0.8.3
u24 x86_64 postgresql-17-pg-xenophile
PIGSTY 0.8.3
postgresql-16-pg-xenophile
PIGSTY 0.8.3
postgresql-15-pg-xenophile
PIGSTY 0.8.3
postgresql-14-pg-xenophile
PIGSTY 0.8.3
postgresql-13-pg-xenophile
PIGSTY 0.8.3
u24 aarch64 postgresql-17-pg-xenophile
PIGSTY 0.8.3
postgresql-16-pg-xenophile
PIGSTY 0.8.3
postgresql-15-pg-xenophile
PIGSTY 0.8.3
postgresql-14-pg-xenophile
PIGSTY 0.8.3
postgresql-13-pg-xenophile
PIGSTY 0.8.3

Installation

Install pg_xenophile via the pig CLI tool:

pig ext install pg_xenophile

Install pg_xenophile via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_xenophile"]}' # -l <cls>

Install pg_xenophile RPM from YUM repo directly:

dnf install pg_xenophile_17;
dnf install pg_xenophile_16;
dnf install pg_xenophile_15;
dnf install pg_xenophile_14;
dnf install pg_xenophile_13;

Install pg_xenophile DEB from APT repo directly:

apt install postgresql-17-pg-xenophile;
apt install postgresql-16-pg-xenophile;
apt install postgresql-15-pg-xenophile;
apt install postgresql-14-pg-xenophile;
apt install postgresql-13-pg-xenophile;

Enable pg_xenophile extension on PostgreSQL cluster:

CREATE EXTENSION pg_xenophile;



13 - currency

Custom PostgreSQL currency type in 1Byte

Overview

PIGSTY 3rd Party Extension: pg_currency : Custom PostgreSQL currency type in 1Byte

Information

Metadata

  • Latest Version: 0.0.3
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_currency_$v*
  • RPM Ver : 0.0.3
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-currency
  • DEB Ver : 0.0.3
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_currency_17
PIGSTY 0.0.3
pg_currency_16
PIGSTY 0.0.3
pg_currency_15
PIGSTY 0.0.3
pg_currency_14
PIGSTY 0.0.3
pg_currency_13
PIGSTY 0.0.3
el8 aarch64 pg_currency_17
PIGSTY 0.0.3
pg_currency_16
PIGSTY 0.0.3
pg_currency_15
PIGSTY 0.0.3
pg_currency_14
PIGSTY 0.0.3
pg_currency_13
PIGSTY 0.0.3
el9 x86_64 pg_currency_17
PIGSTY 0.0.3
pg_currency_16
PIGSTY 0.0.3
pg_currency_15
PIGSTY 0.0.3
pg_currency_14
PIGSTY 0.0.3
pg_currency_13
PIGSTY 0.0.3
el9 aarch64 pg_currency_17
PIGSTY 0.0.3
pg_currency_16
PIGSTY 0.0.3
pg_currency_15
PIGSTY 0.0.3
pg_currency_14
PIGSTY 0.0.3
pg_currency_13
PIGSTY 0.0.3
d12 x86_64 postgresql-17-pg-currency
PIGSTY 0.0.3
postgresql-16-pg-currency
PIGSTY 0.0.3
postgresql-15-pg-currency
PIGSTY 0.0.3
postgresql-14-pg-currency
PIGSTY 0.0.3
postgresql-13-pg-currency
PIGSTY 0.0.3
d12 aarch64 postgresql-17-pg-currency
PIGSTY 0.0.3
postgresql-16-pg-currency
PIGSTY 0.0.3
postgresql-15-pg-currency
PIGSTY 0.0.3
postgresql-14-pg-currency
PIGSTY 0.0.3
postgresql-13-pg-currency
PIGSTY 0.0.3
u22 x86_64 postgresql-17-pg-currency
PIGSTY 0.0.3
postgresql-16-pg-currency
PIGSTY 0.0.3
postgresql-15-pg-currency
PIGSTY 0.0.3
postgresql-14-pg-currency
PIGSTY 0.0.3
postgresql-13-pg-currency
PIGSTY 0.0.3
u22 aarch64 postgresql-17-pg-currency
PIGSTY 0.0.3
postgresql-16-pg-currency
PIGSTY 0.0.3
postgresql-15-pg-currency
PIGSTY 0.0.3
postgresql-14-pg-currency
PIGSTY 0.0.3
postgresql-13-pg-currency
PIGSTY 0.0.3
u24 x86_64 postgresql-17-pg-currency
PIGSTY 0.0.3
postgresql-16-pg-currency
PIGSTY 0.0.3
postgresql-15-pg-currency
PIGSTY 0.0.3
postgresql-14-pg-currency
PIGSTY 0.0.3
postgresql-13-pg-currency
PIGSTY 0.0.3
u24 aarch64 postgresql-17-pg-currency
PIGSTY 0.0.3
postgresql-16-pg-currency
PIGSTY 0.0.3
postgresql-15-pg-currency
PIGSTY 0.0.3
postgresql-14-pg-currency
PIGSTY 0.0.3
postgresql-13-pg-currency
PIGSTY 0.0.3

Installation

Install currency via the pig CLI tool:


pig ext install pg_currency; # Extension Namepig ext install currency; # normalized package name

Install pg_currency via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_currency"]}' # -l <cls>

Install pg_currency RPM from YUM repo directly:

dnf install pg_currency_17*;
dnf install pg_currency_16*;
dnf install pg_currency_15*;
dnf install pg_currency_14*;
dnf install pg_currency_13*;

Install pg_currency DEB from APT repo directly:

apt install postgresql-17-pg-currency;
apt install postgresql-16-pg-currency;
apt install postgresql-15-pg-currency;
apt install postgresql-14-pg-currency;
apt install postgresql-13-pg-currency;

Enable currency extension on PostgreSQL cluster:

CREATE EXTENSION currency;



14 - pgmp

Multiple Precision Arithmetic extension

Overview

PGDG 1st Party Extension: pgmp : Multiple Precision Arithmetic extension

Information

Metadata

  • Latest Version: 1.1
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PGDG
  • RPM Name: pgmp_$v*
  • RPM Ver : 1.1
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgmp
  • DEB Ver : 1.1
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pgmp_17
PGDG 1.0.5
pgmp_16
PGDG 1.0.5
pgmp_15
PGDG 1.0.4
pgmp_14
PGDG 1.0.4
el8 aarch64 pgmp_17
PGDG 1.0.5
pgmp_16
PGDG 1.0.5
pgmp_15
PGDG 1.0.4
pgmp_14
PGDG 1.0.4
pgmp_13
PGDG 1.0.4
el9 x86_64 pgmp_17
PGDG 1.0.5
pgmp_16
PGDG 1.0.5
pgmp_15
PGDG 1.0.4
el9 aarch64 pgmp_17
PGDG 1.0.5
pgmp_16
PGDG 1.0.5
pgmp_15
PGDG 1.0.4
pgmp_14
PGDG 1.0.4
pgmp_13
PGDG 1.0.4
d12 x86_64 postgresql-17-pgmp
PGDG 1.0.5
postgresql-16-pgmp
PGDG 1.0.5
postgresql-15-pgmp
PGDG 1.0.5
postgresql-14-pgmp
PGDG 1.0.5
postgresql-13-pgmp
PGDG 1.0.5
d12 aarch64 postgresql-17-pgmp
PGDG 1.0.5
postgresql-16-pgmp
PGDG 1.0.5
postgresql-15-pgmp
PGDG 1.0.5
postgresql-14-pgmp
PGDG 1.0.5
postgresql-13-pgmp
PGDG 1.0.5
u22 x86_64 postgresql-17-pgmp
PGDG 1.0.5
postgresql-16-pgmp
PGDG 1.0.5
postgresql-15-pgmp
PGDG 1.0.5
postgresql-14-pgmp
PGDG 1.0.5
postgresql-13-pgmp
PGDG 1.0.5
u22 aarch64 postgresql-17-pgmp
PGDG 1.0.5
postgresql-16-pgmp
PGDG 1.0.5
postgresql-15-pgmp
PGDG 1.0.5
postgresql-14-pgmp
PGDG 1.0.5
postgresql-13-pgmp
PGDG 1.0.5
u24 x86_64 postgresql-17-pgmp
PGDG 1.0.5
postgresql-16-pgmp
PGDG 1.0.5
postgresql-15-pgmp
PGDG 1.0.5
postgresql-14-pgmp
PGDG 1.0.5
postgresql-13-pgmp
PGDG 1.0.5
u24 aarch64 postgresql-17-pgmp
PGDG 1.0.5
postgresql-16-pgmp
PGDG 1.0.5
postgresql-15-pgmp
PGDG 1.0.5
postgresql-14-pgmp
PGDG 1.0.5
postgresql-13-pgmp
PGDG 1.0.5

Installation

Install pgmp via the pig CLI tool:

pig ext install pgmp

Install pgmp via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgmp"]}' # -l <cls>

Install pgmp RPM from YUM repo directly:

dnf install pgmp_17*;
dnf install pgmp_16*;
dnf install pgmp_15*;

Install pgmp DEB from APT repo directly:

apt install postgresql-17-pgmp;
apt install postgresql-16-pgmp;
apt install postgresql-15-pgmp;
apt install postgresql-14-pgmp;
apt install postgresql-13-pgmp;

Enable pgmp extension on PostgreSQL cluster:

CREATE EXTENSION pgmp;



15 - numeral

numeral datatypes extension

Overview

MIXED 3rd Party Extension: numeral : numeral datatypes extension

Information

Metadata

  • Latest Version: 1
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: numeral_$v*
  • RPM Ver : 1
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-numeral
  • DEB Ver : 1
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 numeral_17
PIGSTY 1.3
numeral_16
PIGSTY 1.3
numeral_15
PIGSTY 1.3
numeral_14
PIGSTY 1.3
numeral_13
PIGSTY 1.3
el8 aarch64 numeral_17
PIGSTY 1.3
numeral_16
PIGSTY 1.3
numeral_15
PIGSTY 1.3
numeral_14
PIGSTY 1.3
numeral_13
PIGSTY 1.3
el9 x86_64 numeral_17
PIGSTY 1.3
numeral_16
PIGSTY 1.3
numeral_15
PIGSTY 1.3
numeral_14
PIGSTY 1.3
numeral_13
PIGSTY 1.3
el9 aarch64 numeral_17
PIGSTY 1.3
numeral_16
PIGSTY 1.3
numeral_15
PIGSTY 1.3
numeral_14
PIGSTY 1.3
numeral_13
PIGSTY 1.3
d12 x86_64 postgresql-17-numeral
PGDG 1.3
postgresql-16-numeral
PGDG 1.3
postgresql-15-numeral
PGDG 1.3
postgresql-14-numeral
PGDG 1.3
postgresql-13-numeral
PGDG 1.3
d12 aarch64 postgresql-17-numeral
PGDG 1.3
postgresql-16-numeral
PGDG 1.3
postgresql-15-numeral
PGDG 1.3
postgresql-14-numeral
PGDG 1.3
postgresql-13-numeral
PGDG 1.3
u22 x86_64 postgresql-17-numeral
PGDG 1.3
postgresql-16-numeral
PGDG 1.3
postgresql-15-numeral
PGDG 1.3
postgresql-14-numeral
PGDG 1.3
postgresql-13-numeral
PGDG 1.3
u22 aarch64 postgresql-17-numeral
PGDG 1.3
postgresql-16-numeral
PGDG 1.3
postgresql-15-numeral
PGDG 1.3
postgresql-14-numeral
PGDG 1.3
postgresql-13-numeral
PGDG 1.3
u24 x86_64 postgresql-17-numeral
PGDG 1.3
postgresql-16-numeral
PGDG 1.3
postgresql-15-numeral
PGDG 1.3
postgresql-14-numeral
PGDG 1.3
postgresql-13-numeral
PGDG 1.3
u24 aarch64 postgresql-17-numeral
PGDG 1.3
postgresql-16-numeral
PGDG 1.3
postgresql-15-numeral
PGDG 1.3
postgresql-14-numeral
PGDG 1.3
postgresql-13-numeral
PGDG 1.3

Installation

Install numeral via the pig CLI tool:

pig ext install numeral

Install numeral via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["numeral"]}' # -l <cls>

Install numeral RPM from YUM repo directly:

dnf install numeral_17*;
dnf install numeral_16*;
dnf install numeral_15*;
dnf install numeral_14*;
dnf install numeral_13*;

Install numeral DEB from APT repo directly:

apt install postgresql-17-numeral;
apt install postgresql-16-numeral;
apt install postgresql-15-numeral;
apt install postgresql-14-numeral;
apt install postgresql-13-numeral;

Enable numeral extension on PostgreSQL cluster:

CREATE EXTENSION numeral;



16 - pg_rational

bigint fractions

Overview

MIXED 3rd Party Extension: pg_rational : bigint fractions

Information

Metadata

  • Latest Version: 0.0.2
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_rational_$v*
  • RPM Ver : 0.0.2
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-rational
  • DEB Ver : 0.0.1
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_rational_17
PIGSTY 0.0.2
pg_rational_16
PIGSTY 0.0.2
pg_rational_15
PIGSTY 0.0.2
pg_rational_14
PIGSTY 0.0.2
pg_rational_13
PIGSTY 0.0.2
el8 aarch64 pg_rational_17
PIGSTY 0.0.2
pg_rational_16
PIGSTY 0.0.2
pg_rational_15
PIGSTY 0.0.2
pg_rational_14
PIGSTY 0.0.2
pg_rational_13
PIGSTY 0.0.2
el9 x86_64 pg_rational_17
PIGSTY 0.0.2
pg_rational_16
PIGSTY 0.0.2
pg_rational_15
PIGSTY 0.0.2
pg_rational_14
PIGSTY 0.0.2
pg_rational_13
PIGSTY 0.0.2
el9 aarch64 pg_rational_17
PIGSTY 0.0.2
pg_rational_16
PIGSTY 0.0.2
pg_rational_15
PIGSTY 0.0.2
pg_rational_14
PIGSTY 0.0.2
pg_rational_13
PIGSTY 0.0.2
d12 x86_64 postgresql-17-rational
PGDG 0.0.2
postgresql-16-rational
PGDG 0.0.2
postgresql-15-rational
PGDG 0.0.2
postgresql-14-rational
PGDG 0.0.2
postgresql-13-rational
PGDG 0.0.2
d12 aarch64 postgresql-17-rational
PGDG 0.0.2
postgresql-16-rational
PGDG 0.0.2
postgresql-15-rational
PGDG 0.0.2
postgresql-14-rational
PGDG 0.0.2
postgresql-13-rational
PGDG 0.0.2
u22 x86_64 postgresql-17-rational
PGDG 0.0.2
postgresql-16-rational
PGDG 0.0.2
postgresql-15-rational
PGDG 0.0.2
postgresql-14-rational
PGDG 0.0.2
postgresql-13-rational
PGDG 0.0.2
u22 aarch64 postgresql-17-rational
PGDG 0.0.2
postgresql-16-rational
PGDG 0.0.2
postgresql-15-rational
PGDG 0.0.2
postgresql-14-rational
PGDG 0.0.2
postgresql-13-rational
PGDG 0.0.2
u24 x86_64 postgresql-17-rational
PGDG 0.0.2
postgresql-16-rational
PGDG 0.0.2
postgresql-15-rational
PGDG 0.0.2
postgresql-14-rational
PGDG 0.0.2
postgresql-13-rational
PGDG 0.0.2
u24 aarch64 postgresql-17-rational
PGDG 0.0.2
postgresql-16-rational
PGDG 0.0.2
postgresql-15-rational
PGDG 0.0.2
postgresql-14-rational
PGDG 0.0.2
postgresql-13-rational
PGDG 0.0.2

Installation

Install pg_rational via the pig CLI tool:

pig ext install pg_rational

Install pg_rational via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_rational"]}' # -l <cls>

Install pg_rational RPM from YUM repo directly:

dnf install pg_rational_17*;
dnf install pg_rational_16*;
dnf install pg_rational_15*;
dnf install pg_rational_14*;
dnf install pg_rational_13*;

Install pg_rational DEB from APT repo directly:

apt install postgresql-17-rational;
apt install postgresql-16-rational;
apt install postgresql-15-rational;
apt install postgresql-14-rational;
apt install postgresql-13-rational;

Enable pg_rational extension on PostgreSQL cluster:

CREATE EXTENSION pg_rational;



17 - uint

unsigned integer types

Overview

MIXED 3rd Party Extension: pguint : unsigned integer types

Information

Metadata

  • Latest Version: 0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pguint_$v*
  • RPM Ver : 0
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pguint
  • DEB Ver : 0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pguint_17
PGDG 1.20231206
pguint_16
PIGSTY 1.20231206
pguint_15
PIGSTY 1.20231206
pguint_14
PIGSTY 1.20231206
pguint_13
PIGSTY 1.20231206
el8 aarch64 pguint_17
PGDG 1.20231206
pguint_16
PIGSTY 1.20231206
pguint_15
PIGSTY 1.20231206
pguint_14
PIGSTY 1.20231206
pguint_13
PIGSTY 1.20231206
el9 x86_64 pguint_17
PGDG 1.20231206
pguint_16
PIGSTY 1.20231206
pguint_15
PIGSTY 1.20231206
pguint_14
PIGSTY 1.20231206
pguint_13
PIGSTY 1.20231206
el9 aarch64 pguint_17
PGDG 1.20231206
pguint_16
PIGSTY 1.20231206
pguint_15
PIGSTY 1.20231206
pguint_14
PIGSTY 1.20231206
pguint_13
PIGSTY 1.20231206
d12 x86_64 postgresql-17-pguint
PIGSTY 1.20231206
postgresql-16-pguint
PIGSTY 1.20231206
postgresql-15-pguint
PIGSTY 1.20231206
postgresql-14-pguint
PIGSTY 1.20231206
postgresql-13-pguint
PIGSTY 1.20231206
d12 aarch64 postgresql-17-pguint
PIGSTY 1.20231206
postgresql-16-pguint
PIGSTY 1.20231206
postgresql-15-pguint
PIGSTY 1.20231206
postgresql-14-pguint
PIGSTY 1.20231206
postgresql-13-pguint
PIGSTY 1.20231206
u22 x86_64 postgresql-17-pguint
PIGSTY 1.20231206
postgresql-16-pguint
PIGSTY 1.20231206
postgresql-15-pguint
PIGSTY 1.20231206
postgresql-14-pguint
PIGSTY 1.20231206
postgresql-13-pguint
PIGSTY 1.20231206
u22 aarch64 postgresql-17-pguint
PIGSTY 1.20231206
postgresql-16-pguint
PIGSTY 1.20231206
postgresql-15-pguint
PIGSTY 1.20231206
postgresql-14-pguint
PIGSTY 1.20231206
postgresql-13-pguint
PIGSTY 1.20231206
u24 x86_64 postgresql-17-pguint
PIGSTY 1.20231206
postgresql-16-pguint
PIGSTY 1.20231206
postgresql-15-pguint
PIGSTY 1.20231206
postgresql-14-pguint
PIGSTY 1.20231206
postgresql-13-pguint
PIGSTY 1.20231206
u24 aarch64 postgresql-17-pguint
PIGSTY 1.20231206
postgresql-16-pguint
PIGSTY 1.20231206
postgresql-15-pguint
PIGSTY 1.20231206
postgresql-14-pguint
PIGSTY 1.20231206
postgresql-13-pguint
PIGSTY 1.20231206

Installation

Install uint via the pig CLI tool:


pig ext install pguint; # Extension Namepig ext install uint; # normalized package name

Install pguint via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pguint"]}' # -l <cls>

Install pguint RPM from YUM repo directly:

dnf install pguint_17*;
dnf install pguint_16*;
dnf install pguint_15*;
dnf install pguint_14*;
dnf install pguint_13*;

Install pguint DEB from APT repo directly:

apt install postgresql-17-pguint;
apt install postgresql-16-pguint;
apt install postgresql-15-pguint;
apt install postgresql-14-pguint;
apt install postgresql-13-pguint;

Enable uint extension on PostgreSQL cluster:

CREATE EXTENSION uint;



18 - uint128

Native uint128 type

Overview

PIGSTY 3rd Party Extension: pg_uint128 : Native uint128 type

Information

Metadata

  • Latest Version: 1.0.0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_uint128_$v*
  • RPM Ver : 1.0.0
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-uint128
  • DEB Ver : 1.0.0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_uint128_17
PIGSTY 1.0.0
pg_uint128_16
PIGSTY 1.0.0
pg_uint128_15
PIGSTY 1.0.0
pg_uint128_14
PIGSTY 1.0.0
pg_uint128_13
PIGSTY 1.0.0
el8 aarch64 pg_uint128_17
PIGSTY 1.0.0
pg_uint128_16
PIGSTY 1.0.0
pg_uint128_15
PIGSTY 1.0.0
pg_uint128_14
PIGSTY 1.0.0
pg_uint128_13
PIGSTY 1.0.0
el9 x86_64 pg_uint128_17
PIGSTY 1.0.0
pg_uint128_16
PIGSTY 1.0.0
pg_uint128_15
PIGSTY 1.0.0
pg_uint128_14
PIGSTY 1.0.0
pg_uint128_13
PIGSTY 1.0.0
el9 aarch64 pg_uint128_17
PIGSTY 1.0.0
pg_uint128_16
PIGSTY 1.0.0
pg_uint128_15
PIGSTY 1.0.0
pg_uint128_14
PIGSTY 1.0.0
pg_uint128_13
PIGSTY 1.0.0
d12 x86_64 postgresql-17-pg-uint128
PIGSTY 1.0.0
postgresql-16-pg-uint128
PIGSTY 1.0.0
postgresql-15-pg-uint128
PIGSTY 1.0.0
postgresql-14-pg-uint128
PIGSTY 1.0.0
postgresql-13-pg-uint128
PIGSTY 1.0.0
d12 aarch64 postgresql-17-pg-uint128
PIGSTY 1.0.0
postgresql-16-pg-uint128
PIGSTY 1.0.0
postgresql-15-pg-uint128
PIGSTY 1.0.0
postgresql-14-pg-uint128
PIGSTY 1.0.0
postgresql-13-pg-uint128
PIGSTY 1.0.0
u22 x86_64 postgresql-17-pg-uint128
PIGSTY 1.0.0
postgresql-16-pg-uint128
PIGSTY 1.0.0
postgresql-15-pg-uint128
PIGSTY 1.0.0
postgresql-14-pg-uint128
PIGSTY 1.0.0
postgresql-13-pg-uint128
PIGSTY 1.0.0
u22 aarch64 postgresql-17-pg-uint128
PIGSTY 1.0.0
postgresql-16-pg-uint128
PIGSTY 1.0.0
postgresql-15-pg-uint128
PIGSTY 1.0.0
postgresql-14-pg-uint128
PIGSTY 1.0.0
postgresql-13-pg-uint128
PIGSTY 1.0.0
u24 x86_64 postgresql-17-pg-uint128
PIGSTY 1.0.0
postgresql-16-pg-uint128
PIGSTY 1.0.0
postgresql-15-pg-uint128
PIGSTY 1.0.0
postgresql-14-pg-uint128
PIGSTY 1.0.0
postgresql-13-pg-uint128
PIGSTY 1.0.0
u24 aarch64 postgresql-17-pg-uint128
PIGSTY 1.0.0
postgresql-16-pg-uint128
PIGSTY 1.0.0
postgresql-15-pg-uint128
PIGSTY 1.0.0
postgresql-14-pg-uint128
PIGSTY 1.0.0
postgresql-13-pg-uint128
PIGSTY 1.0.0

Installation

Install uint128 via the pig CLI tool:


pig ext install pg_uint128; # Extension Namepig ext install uint128; # normalized package name

Install pg_uint128 via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_uint128"]}' # -l <cls>

Install pg_uint128 RPM from YUM repo directly:

dnf install pg_uint128_17*;
dnf install pg_uint128_16*;
dnf install pg_uint128_15*;
dnf install pg_uint128_14*;
dnf install pg_uint128_13*;

Install pg_uint128 DEB from APT repo directly:

apt install postgresql-17-pg-uint128;
apt install postgresql-16-pg-uint128;
apt install postgresql-15-pg-uint128;
apt install postgresql-14-pg-uint128;
apt install postgresql-13-pg-uint128;

Enable uint128 extension on PostgreSQL cluster:

CREATE EXTENSION uint128;



19 - hashtypes

sha1, md5 and other data types for PostgreSQL

Overview

PIGSTY 3rd Party Extension: hashtypes : sha1, md5 and other data types for PostgreSQL

Information

Metadata

  • Latest Version: 0.1.5
  • Postgres Support: 17,16,15,14
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can be installed into other schemas
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: hashtypes_$v*
  • RPM Ver : 0.1.5
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-hashtypes
  • DEB Ver : 0.1.5
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 hashtypes_17
PIGSTY 0.1.5
hashtypes_16
PIGSTY 0.1.5
hashtypes_15
PIGSTY 0.1.5
hashtypes_14
PIGSTY 0.1.5
el8 aarch64 hashtypes_17
PIGSTY 0.1.5
hashtypes_16
PIGSTY 0.1.5
hashtypes_15
PIGSTY 0.1.5
hashtypes_14
PIGSTY 0.1.5
el9 x86_64 hashtypes_17
PIGSTY 0.1.5
hashtypes_16
PIGSTY 0.1.5
hashtypes_15
PIGSTY 0.1.5
hashtypes_14
PIGSTY 0.1.5
el9 aarch64 hashtypes_17
PIGSTY 0.1.5
hashtypes_16
PIGSTY 0.1.5
hashtypes_15
PIGSTY 0.1.5
hashtypes_14
PIGSTY 0.1.5
d12 x86_64 postgresql-17-hashtypes
PIGSTY 0.1.5
postgresql-16-hashtypes
PIGSTY 0.1.5
postgresql-15-hashtypes
PIGSTY 0.1.5
postgresql-14-hashtypes
PIGSTY 0.1.5
postgresql-13-hashtypes
PIGSTY 0.1.5
d12 aarch64 postgresql-17-hashtypes
PIGSTY 0.1.5
postgresql-16-hashtypes
PIGSTY 0.1.5
postgresql-15-hashtypes
PIGSTY 0.1.5
postgresql-14-hashtypes
PIGSTY 0.1.5
postgresql-13-hashtypes
PIGSTY 0.1.5
u22 x86_64 postgresql-17-hashtypes
PIGSTY 0.1.5
postgresql-16-hashtypes
PIGSTY 0.1.5
postgresql-15-hashtypes
PIGSTY 0.1.5
postgresql-14-hashtypes
PIGSTY 0.1.5
postgresql-13-hashtypes
PIGSTY 0.1.5
u22 aarch64 postgresql-17-hashtypes
PIGSTY 0.1.5
postgresql-16-hashtypes
PIGSTY 0.1.5
postgresql-15-hashtypes
PIGSTY 0.1.5
postgresql-14-hashtypes
PIGSTY 0.1.5
postgresql-13-hashtypes
PIGSTY 0.1.5
u24 x86_64 postgresql-17-hashtypes
PIGSTY 0.1.5
postgresql-16-hashtypes
PIGSTY 0.1.5
postgresql-15-hashtypes
PIGSTY 0.1.5
postgresql-14-hashtypes
PIGSTY 0.1.5
postgresql-13-hashtypes
PIGSTY 0.1.5
u24 aarch64 postgresql-17-hashtypes
PIGSTY 0.1.5
postgresql-16-hashtypes
PIGSTY 0.1.5
postgresql-15-hashtypes
PIGSTY 0.1.5
postgresql-14-hashtypes
PIGSTY 0.1.5
postgresql-13-hashtypes
PIGSTY 0.1.5

Installation

Install hashtypes via the pig CLI tool:

pig ext install hashtypes

Install hashtypes via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["hashtypes"]}' # -l <cls>

Install hashtypes RPM from YUM repo directly:

dnf install hashtypes_17*;
dnf install hashtypes_16*;
dnf install hashtypes_15*;
dnf install hashtypes_14*;

Install hashtypes DEB from APT repo directly:

apt install postgresql-17-hashtypes;
apt install postgresql-16-hashtypes;
apt install postgresql-15-hashtypes;
apt install postgresql-14-hashtypes;

Enable hashtypes extension on PostgreSQL cluster:

CREATE EXTENSION hashtypes;



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

  • Latest Version: 2.4
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PGDG
  • RPM Name: ip4r_$v*
  • RPM Ver : 2.4
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-ip4r
  • DEB Ver : 2.4
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 ip4r_17
PGDG 2.4.2
ip4r_16
PGDG 2.4.2
ip4r_15
PGDG 2.4.2
ip4r_14
PGDG 2.4.2
ip4r_13
PGDG 2.4.2
el8 aarch64 ip4r_17
PGDG 2.4.2
ip4r_16
PGDG 2.4.2
ip4r_15
PGDG 2.4.2
ip4r_14
PGDG 2.4.2
ip4r_13
PGDG 2.4.2
el9 x86_64 ip4r_17
PGDG 2.4.2
ip4r_16
PGDG 2.4.2
ip4r_15
PGDG 2.4.2
ip4r_14
PGDG 2.4.2
ip4r_13
PGDG 2.4.2
el9 aarch64 ip4r_17
PGDG 2.4.2
ip4r_16
PGDG 2.4.2
ip4r_15
PGDG 2.4.2
ip4r_14
PGDG 2.4.2
ip4r_13
PGDG 2.4.2
d12 x86_64 postgresql-17-ip4r
PGDG 2.4.2
postgresql-16-ip4r
PGDG 2.4.2
postgresql-15-ip4r
PGDG 2.4.2
postgresql-14-ip4r
PGDG 2.4.2
postgresql-13-ip4r
PGDG 2.4.2
d12 aarch64 postgresql-17-ip4r
PGDG 2.4.2
postgresql-16-ip4r
PGDG 2.4.2
postgresql-15-ip4r
PGDG 2.4.2
postgresql-14-ip4r
PGDG 2.4.2
postgresql-13-ip4r
PGDG 2.4.2
u22 x86_64 postgresql-17-ip4r
PGDG 2.4.2
postgresql-16-ip4r
PGDG 2.4.2
postgresql-15-ip4r
PGDG 2.4.2
postgresql-14-ip4r
PGDG 2.4.2
postgresql-13-ip4r
PGDG 2.4.2
u22 aarch64 postgresql-17-ip4r
PGDG 2.4.2
postgresql-16-ip4r
PGDG 2.4.2
postgresql-15-ip4r
PGDG 2.4.2
postgresql-14-ip4r
PGDG 2.4.2
postgresql-13-ip4r
PGDG 2.4.2
u24 x86_64 postgresql-17-ip4r
PGDG 2.4.2
postgresql-16-ip4r
PGDG 2.4.2
postgresql-15-ip4r
PGDG 2.4.2
postgresql-14-ip4r
PGDG 2.4.2
postgresql-13-ip4r
PGDG 2.4.2
u24 aarch64 postgresql-17-ip4r
PGDG 2.4.2
postgresql-16-ip4r
PGDG 2.4.2
postgresql-15-ip4r
PGDG 2.4.2
postgresql-14-ip4r
PGDG 2.4.2
postgresql-13-ip4r
PGDG 2.4.2

Installation

Install ip4r via the pig CLI tool:

pig ext install ip4r

Install ip4r via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["ip4r"]}' # -l <cls>

Install ip4r RPM from YUM repo directly:

dnf install ip4r_17*;
dnf install ip4r_16*;
dnf install ip4r_15*;
dnf install ip4r_14*;
dnf install ip4r_13*;

Install ip4r DEB from APT repo directly:

apt install postgresql-17-ip4r;
apt install postgresql-16-ip4r;
apt install postgresql-15-ip4r;
apt install postgresql-14-ip4r;
apt install postgresql-13-ip4r;

Enable ip4r extension on PostgreSQL cluster:

CREATE EXTENSION ip4r;



21 - pg_duration

data type for representing durations

Overview

PIGSTY 3rd Party Extension: pg_duration : data type for representing durations

Information

Metadata

  • Latest Version: 1.0.1
  • Postgres Support: 17
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_duration_$v*
  • RPM Ver : 1.0.1
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-duration
  • DEB Ver : 1.0.1
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_duration_17
PIGSTY 1.0.1
el8 aarch64 pg_duration_17
PIGSTY 1.0.1
el9 x86_64 pg_duration_17
PIGSTY 1.0.1
el9 aarch64 pg_duration_17
PIGSTY 1.0.1
d12 x86_64 postgresql-17-pg-duration
PIGSTY 1.0.1
d12 aarch64 postgresql-17-pg-duration
PIGSTY 1.0.1
u22 x86_64 postgresql-17-pg-duration
PIGSTY 1.0.1
u22 aarch64 postgresql-17-pg-duration
PIGSTY 1.0.1
u24 x86_64 postgresql-17-pg-duration
PIGSTY 1.0.1
u24 aarch64 postgresql-17-pg-duration
PIGSTY 1.0.1

Installation

Install pg_duration via the pig CLI tool:

pig ext install pg_duration

Install pg_duration via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_duration"]}' # -l <cls>

Install pg_duration RPM from YUM repo directly:

dnf install pg_duration_17*;

Install pg_duration DEB from APT repo directly:

apt install postgresql-17-pg-duration;

Enable pg_duration extension on PostgreSQL cluster:

CREATE EXTENSION pg_duration;



22 - uri

URI Data type for PostgreSQL

Overview

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

Information

Metadata

  • Latest Version: 1
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_uri_$v*
  • RPM Ver : 1
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-uri
  • DEB Ver : 1
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_uri_17
PIGSTY 1.20151224
pg_uri_16
PIGSTY 1.20151224
pg_uri_15
PIGSTY 1.20151224
pg_uri_14
PIGSTY 1.20151224
pg_uri_13
PIGSTY 1.20151224
el8 aarch64 pg_uri_17
PIGSTY 1.20151224
pg_uri_16
PIGSTY 1.20151224
pg_uri_15
PIGSTY 1.20151224
pg_uri_14
PIGSTY 1.20151224
pg_uri_13
PIGSTY 1.20151224
el9 x86_64 pg_uri_17
PIGSTY 1.20151224
pg_uri_16
PIGSTY 1.20151224
pg_uri_15
PIGSTY 1.20151224
pg_uri_14
PIGSTY 1.20151224
pg_uri_13
PIGSTY 1.20151224
el9 aarch64 pg_uri_17
PIGSTY 1.20151224
pg_uri_16
PIGSTY 1.20151224
pg_uri_15
PIGSTY 1.20151224
pg_uri_14
PIGSTY 1.20151224
pg_uri_13
PIGSTY 1.20151224
d12 x86_64 postgresql-17-pg-uri
PIGSTY 1.20151224
postgresql-16-pg-uri
PIGSTY 1.20151224
postgresql-15-pg-uri
PIGSTY 1.20151224
postgresql-14-pg-uri
PIGSTY 1.20151224
postgresql-13-pg-uri
PIGSTY 1.20151224
d12 aarch64 postgresql-17-pg-uri
PIGSTY 1.20151224
postgresql-16-pg-uri
PIGSTY 1.20151224
postgresql-15-pg-uri
PIGSTY 1.20151224
postgresql-14-pg-uri
PIGSTY 1.20151224
postgresql-13-pg-uri
PIGSTY 1.20151224
u22 x86_64 postgresql-17-pg-uri
PIGSTY 1.20151224
postgresql-16-pg-uri
PIGSTY 1.20151224
postgresql-15-pg-uri
PIGSTY 1.20151224
postgresql-14-pg-uri
PIGSTY 1.20151224
postgresql-13-pg-uri
PIGSTY 1.20151224
u22 aarch64 postgresql-17-pg-uri
PIGSTY 1.20151224
postgresql-16-pg-uri
PIGSTY 1.20151224
postgresql-15-pg-uri
PIGSTY 1.20151224
postgresql-14-pg-uri
PIGSTY 1.20151224
postgresql-13-pg-uri
PIGSTY 1.20151224
u24 x86_64 postgresql-17-pg-uri
PIGSTY 1.20151224
postgresql-16-pg-uri
PIGSTY 1.20151224
postgresql-15-pg-uri
PIGSTY 1.20151224
postgresql-14-pg-uri
PIGSTY 1.20151224
postgresql-13-pg-uri
PIGSTY 1.20151224
u24 aarch64 postgresql-17-pg-uri
PIGSTY 1.20151224
postgresql-16-pg-uri
PIGSTY 1.20151224
postgresql-15-pg-uri
PIGSTY 1.20151224
postgresql-14-pg-uri
PIGSTY 1.20151224
postgresql-13-pg-uri
PIGSTY 1.20151224

Installation

Install uri via the pig CLI tool:


pig ext install pg_uri; # Extension Namepig ext install uri; # normalized package name

Install pg_uri via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_uri"]}' # -l <cls>

Install pg_uri RPM from YUM repo directly:

dnf install pg_uri_17*;
dnf install pg_uri_16*;
dnf install pg_uri_15*;
dnf install pg_uri_14*;
dnf install pg_uri_13*;

Install pg_uri DEB from APT repo directly:

apt install postgresql-17-pg-uri;
apt install postgresql-16-pg-uri;
apt install postgresql-15-pg-uri;
apt install postgresql-14-pg-uri;
apt install postgresql-13-pg-uri;

Enable uri extension on PostgreSQL cluster:

CREATE EXTENSION uri;



23 - emailaddr

Email address type for PostgreSQL

Overview

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

Information

Metadata

  • Latest Version: 0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: pg_emailaddr_$v*
  • RPM Ver : 0
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-emailaddr
  • DEB Ver : 0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 pg_emailaddr_17
PIGSTY 0
pg_emailaddr_16
PIGSTY 0
pg_emailaddr_15
PIGSTY 0
pg_emailaddr_14
PIGSTY 0
pg_emailaddr_13
PIGSTY 0
el8 aarch64 pg_emailaddr_17
PIGSTY 0
pg_emailaddr_16
PIGSTY 0
pg_emailaddr_15
PIGSTY 0
pg_emailaddr_14
PIGSTY 0
pg_emailaddr_13
PIGSTY 0
el9 x86_64 pg_emailaddr_17
PIGSTY 0
pg_emailaddr_16
PIGSTY 0
pg_emailaddr_15
PIGSTY 0
pg_emailaddr_14
PIGSTY 0
pg_emailaddr_13
PIGSTY 0
el9 aarch64 pg_emailaddr_17
PIGSTY 0
pg_emailaddr_16
PIGSTY 0
pg_emailaddr_15
PIGSTY 0
pg_emailaddr_14
PIGSTY 0
pg_emailaddr_13
PIGSTY 0
d12 x86_64 postgresql-17-pg-emailaddr
PIGSTY 0
postgresql-16-pg-emailaddr
PIGSTY 0
postgresql-15-pg-emailaddr
PIGSTY 0
postgresql-14-pg-emailaddr
PIGSTY 0
postgresql-13-pg-emailaddr
PIGSTY 0
d12 aarch64 postgresql-17-pg-emailaddr
PIGSTY 0
postgresql-16-pg-emailaddr
PIGSTY 0
postgresql-15-pg-emailaddr
PIGSTY 0
postgresql-14-pg-emailaddr
PIGSTY 0
postgresql-13-pg-emailaddr
PIGSTY 0
u22 x86_64 postgresql-17-pg-emailaddr
PIGSTY 0
postgresql-16-pg-emailaddr
PIGSTY 0
postgresql-15-pg-emailaddr
PIGSTY 0
postgresql-14-pg-emailaddr
PIGSTY 0
postgresql-13-pg-emailaddr
PIGSTY 0
u22 aarch64 postgresql-17-pg-emailaddr
PIGSTY 0
postgresql-16-pg-emailaddr
PIGSTY 0
postgresql-15-pg-emailaddr
PIGSTY 0
postgresql-14-pg-emailaddr
PIGSTY 0
postgresql-13-pg-emailaddr
PIGSTY 0
u24 x86_64 postgresql-17-pg-emailaddr
PIGSTY 0
postgresql-16-pg-emailaddr
PIGSTY 0
postgresql-15-pg-emailaddr
PIGSTY 0
postgresql-14-pg-emailaddr
PIGSTY 0
postgresql-13-pg-emailaddr
PIGSTY 0
u24 aarch64 postgresql-17-pg-emailaddr
PIGSTY 0
postgresql-16-pg-emailaddr
PIGSTY 0
postgresql-15-pg-emailaddr
PIGSTY 0
postgresql-14-pg-emailaddr
PIGSTY 0
postgresql-13-pg-emailaddr
PIGSTY 0

Installation

Install emailaddr via the pig CLI tool:


pig ext install pgemailaddr; # Extension Namepig ext install emailaddr; # normalized package name

Install pgemailaddr via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgemailaddr"]}' # -l <cls>

Install pgemailaddr RPM from YUM repo directly:

dnf install pg_emailaddr_17*;
dnf install pg_emailaddr_16*;
dnf install pg_emailaddr_15*;
dnf install pg_emailaddr_14*;
dnf install pg_emailaddr_13*;

Install pgemailaddr DEB from APT repo directly:

apt install postgresql-17-pg-emailaddr;
apt install postgresql-16-pg-emailaddr;
apt install postgresql-15-pg-emailaddr;
apt install postgresql-14-pg-emailaddr;
apt install postgresql-13-pg-emailaddr;

Enable emailaddr extension on PostgreSQL cluster:

CREATE EXTENSION emailaddr;



24 - acl

ACL Data type

Overview

PIGSTY 3rd Party Extension: pg_acl : ACL Data type

Information

Metadata

  • Latest Version: 1.0.4
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: acl_$v*
  • RPM Ver : 1.0.4
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-acl
  • DEB Ver : 1.0.4
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 acl_17
PIGSTY 1.0.4
acl_16
PIGSTY 1.0.4
acl_15
PIGSTY 1.0.4
acl_14
PIGSTY 1.0.4
acl_13
PIGSTY 1.0.4
el8 aarch64 acl_17
PIGSTY 1.0.4
acl_16
PIGSTY 1.0.4
acl_15
PIGSTY 1.0.4
acl_14
PIGSTY 1.0.4
acl_13
PIGSTY 1.0.4
el9 x86_64 acl_17
PIGSTY 1.0.4
acl_16
PIGSTY 1.0.4
acl_15
PIGSTY 1.0.4
acl_14
PIGSTY 1.0.4
acl_13
PIGSTY 1.0.4
el9 aarch64 acl_17
PIGSTY 1.0.4
acl_16
PIGSTY 1.0.4
acl_15
PIGSTY 1.0.4
acl_14
PIGSTY 1.0.4
acl_13
PIGSTY 1.0.4
d12 x86_64 postgresql-17-acl
PIGSTY 1.0.4
postgresql-16-acl
PIGSTY 1.0.4
postgresql-15-acl
PIGSTY 1.0.4
postgresql-14-acl
PIGSTY 1.0.4
postgresql-13-acl
PIGSTY 1.0.4
d12 aarch64 postgresql-17-acl
PIGSTY 1.0.4
postgresql-16-acl
PIGSTY 1.0.4
postgresql-15-acl
PIGSTY 1.0.4
postgresql-14-acl
PIGSTY 1.0.4
postgresql-13-acl
PIGSTY 1.0.4
u22 x86_64 postgresql-17-acl
PIGSTY 1.0.4
postgresql-16-acl
PIGSTY 1.0.4
postgresql-15-acl
PIGSTY 1.0.4
postgresql-14-acl
PIGSTY 1.0.4
postgresql-13-acl
PIGSTY 1.0.4
u22 aarch64 postgresql-17-acl
PIGSTY 1.0.4
postgresql-16-acl
PIGSTY 1.0.4
postgresql-15-acl
PIGSTY 1.0.4
postgresql-14-acl
PIGSTY 1.0.4
postgresql-13-acl
PIGSTY 1.0.4
u24 x86_64 postgresql-17-acl
PIGSTY 1.0.4
postgresql-16-acl
PIGSTY 1.0.4
postgresql-15-acl
PIGSTY 1.0.4
postgresql-14-acl
PIGSTY 1.0.4
postgresql-13-acl
PIGSTY 1.0.4
u24 aarch64 postgresql-17-acl
PIGSTY 1.0.4
postgresql-16-acl
PIGSTY 1.0.4
postgresql-15-acl
PIGSTY 1.0.4
postgresql-14-acl
PIGSTY 1.0.4
postgresql-13-acl
PIGSTY 1.0.4

Installation

Install acl via the pig CLI tool:


pig ext install pg_acl; # Extension Namepig ext install acl; # normalized package name

Install pg_acl via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_acl"]}' # -l <cls>

Install pg_acl RPM from YUM repo directly:

dnf install acl_17*;
dnf install acl_16*;
dnf install acl_15*;
dnf install acl_14*;
dnf install acl_13*;

Install pg_acl DEB from APT repo directly:

apt install postgresql-17-acl;
apt install postgresql-16-acl;
apt install postgresql-15-acl;
apt install postgresql-14-acl;
apt install postgresql-13-acl;

Enable acl extension on PostgreSQL cluster:

CREATE EXTENSION acl;



25 - debversion

Debian version number data type

Overview

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

Information

Metadata

  • Latest Version: 1.2
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: None
  • RPM Name: N/A
  • RPM Ver : N/A
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-debversion
  • DEB Ver : 1.2
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64 postgresql-17-debversion
PGDG 1.2.0
postgresql-16-debversion
PGDG 1.2.0
postgresql-15-debversion
PGDG 1.2.0
postgresql-14-debversion
PGDG 1.2.0
postgresql-13-debversion
PGDG 1.2.0
d12 aarch64 postgresql-17-debversion
PGDG 1.2.0
postgresql-16-debversion
PGDG 1.2.0
postgresql-15-debversion
PGDG 1.2.0
postgresql-14-debversion
PGDG 1.2.0
postgresql-13-debversion
PGDG 1.2.0
u22 x86_64 postgresql-17-debversion
PGDG 1.2.0
postgresql-16-debversion
PGDG 1.2.0
postgresql-15-debversion
PGDG 1.2.0
postgresql-14-debversion
PGDG 1.2.0
postgresql-13-debversion
PGDG 1.2.0
u22 aarch64 postgresql-17-debversion
PGDG 1.2.0
postgresql-16-debversion
PGDG 1.2.0
postgresql-15-debversion
PGDG 1.2.0
postgresql-14-debversion
PGDG 1.2.0
postgresql-13-debversion
PGDG 1.2.0
u24 x86_64 postgresql-17-debversion
PGDG 1.2.0
postgresql-16-debversion
PGDG 1.2.0
postgresql-15-debversion
PGDG 1.2.0
postgresql-14-debversion
PGDG 1.2.0
postgresql-13-debversion
PGDG 1.2.0
u24 aarch64 postgresql-17-debversion
PGDG 1.2.0
postgresql-16-debversion
PGDG 1.2.0
postgresql-15-debversion
PGDG 1.2.0
postgresql-14-debversion
PGDG 1.2.0
postgresql-13-debversion
PGDG 1.2.0

Installation

Install debversion via the pig CLI tool:

pig ext install debversion

Install debversion via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["debversion"]}' # -l <cls>

Install debversion DEB from APT repo directly:

apt install postgresql-17-debversion;
apt install postgresql-16-debversion;
apt install postgresql-15-debversion;
apt install postgresql-14-debversion;
apt install postgresql-13-debversion;

Enable debversion extension on PostgreSQL cluster:

CREATE EXTENSION debversion;



26 - pg_rrule

RRULE field type for PostgreSQL

Overview

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

Information

Metadata

  • Latest Version: 0.2.0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Can not install to arbitrary schema
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: None
  • RPM Name: N/A
  • RPM Ver : N/A
  • RPM Deps: N/A
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pg-rrule
  • DEB Ver : 0.2.0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64 postgresql-17-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-16-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-15-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-14-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-13-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
d12 aarch64 postgresql-17-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-16-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-15-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-14-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-13-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
u22 x86_64 postgresql-17-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-16-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-15-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-14-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-13-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
u22 aarch64 postgresql-17-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-16-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-15-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-14-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-13-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
u24 x86_64 postgresql-17-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-16-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-15-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-14-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-13-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
u24 aarch64 postgresql-17-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-16-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-15-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-14-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2
postgresql-13-pg-rrule
PGDG 0.2.0+git20211101.d7d10f2

Installation

Install pg_rrule via the pig CLI tool:

pig ext install pg_rrule

Install pg_rrule via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_rrule"]}' # -l <cls>

Install pg_rrule DEB from APT repo directly:

apt install postgresql-17-pg-rrule;
apt install postgresql-16-pg-rrule;
apt install postgresql-15-pg-rrule;
apt install postgresql-14-pg-rrule;
apt install postgresql-13-pg-rrule;

Enable pg_rrule extension on PostgreSQL cluster:

CREATE EXTENSION pg_rrule;



27 - timestamp9

timestamp nanosecond resolution

Overview

MIXED 3rd Party Extension: timestamp9 : timestamp nanosecond resolution

Information

Metadata

  • Latest Version: 1.4.0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PGDG
  • RPM Name: timestamp9_$v*
  • RPM Ver : 1.4.0
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-timestamp9
  • DEB Ver : 1.4.0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 timestamp9_17
PGDG 1.4.0
timestamp9_16
PGDG 1.4.0
timestamp9_15
PGDG 1.3.0
timestamp9_14
PGDG 1.3.0
timestamp9_13
PGDG 1.3.0
el8 aarch64 timestamp9_17
PGDG 1.4.0
timestamp9_16
PGDG 1.4.0
timestamp9_15
PGDG 1.3.0
timestamp9_14
PGDG 1.3.0
timestamp9_13
PGDG 1.3.0
el9 x86_64 timestamp9_17
PGDG 1.4.0
timestamp9_16
PGDG 1.4.0
timestamp9_15
PGDG 1.3.0
timestamp9_14
PGDG 1.3.0
timestamp9_13
PGDG 1.3.0
el9 aarch64 timestamp9_17
PGDG 1.4.0
timestamp9_16
PGDG 1.4.0
timestamp9_15
PGDG 1.3.0
timestamp9_14
PGDG 1.3.0
timestamp9_13
PGDG 1.3.0
d12 x86_64 postgresql-17-timestamp9
PIGSTY 1.4.0
postgresql-16-timestamp9
PIGSTY 1.4.0
postgresql-15-timestamp9
PIGSTY 1.4.0
postgresql-14-timestamp9
PIGSTY 1.4.0
postgresql-13-timestamp9
PIGSTY 1.4.0
d12 aarch64 postgresql-17-timestamp9
PIGSTY 1.4.0
postgresql-16-timestamp9
PIGSTY 1.4.0
postgresql-15-timestamp9
PIGSTY 1.4.0
postgresql-14-timestamp9
PIGSTY 1.4.0
postgresql-13-timestamp9
PIGSTY 1.4.0
u22 x86_64 postgresql-17-timestamp9
PIGSTY 1.4.0
postgresql-16-timestamp9
PIGSTY 1.4.0
postgresql-15-timestamp9
PIGSTY 1.4.0
postgresql-14-timestamp9
PIGSTY 1.4.0
postgresql-13-timestamp9
PIGSTY 1.4.0
u22 aarch64 postgresql-17-timestamp9
PIGSTY 1.4.0
postgresql-16-timestamp9
PIGSTY 1.4.0
postgresql-15-timestamp9
PIGSTY 1.4.0
postgresql-14-timestamp9
PIGSTY 1.4.0
postgresql-13-timestamp9
PIGSTY 1.4.0
u24 x86_64 postgresql-17-timestamp9
PIGSTY 1.4.0
postgresql-16-timestamp9
PIGSTY 1.4.0
postgresql-15-timestamp9
PIGSTY 1.4.0
postgresql-14-timestamp9
PIGSTY 1.4.0
postgresql-13-timestamp9
PIGSTY 1.4.0
u24 aarch64 postgresql-17-timestamp9
PIGSTY 1.4.0
postgresql-16-timestamp9
PIGSTY 1.4.0
postgresql-15-timestamp9
PIGSTY 1.4.0
postgresql-14-timestamp9
PIGSTY 1.4.0
postgresql-13-timestamp9
PIGSTY 1.4.0

Installation

Install timestamp9 via the pig CLI tool:

pig ext install timestamp9

Install timestamp9 via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["timestamp9"]}' # -l <cls>

Install timestamp9 RPM from YUM repo directly:

dnf install timestamp9_17*;
dnf install timestamp9_16*;
dnf install timestamp9_15*;
dnf install timestamp9_14*;
dnf install timestamp9_13*;

Install timestamp9 DEB from APT repo directly:

apt install postgresql-17-timestamp9;
apt install postgresql-16-timestamp9;
apt install postgresql-15-timestamp9;
apt install postgresql-14-timestamp9;
apt install postgresql-13-timestamp9;

Enable timestamp9 extension on PostgreSQL cluster:

CREATE EXTENSION timestamp9;



28 - chkpass

data type for auto-encrypted passwords

Overview

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

Information

Metadata

  • Latest Version: 1.0
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

  • RPM Repo: PIGSTY
  • RPM Name: chkpass_$v*
  • RPM Ver : 1.0
  • RPM Deps: N/A
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-chkpass
  • DEB Ver : 1.0
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 chkpass_17
PIGSTY 1.0
chkpass_16
PIGSTY 1.0
chkpass_15
PIGSTY 1.0
chkpass_14
PIGSTY 1.0
chkpass_13
PIGSTY 1.0
el8 aarch64 chkpass_17
PIGSTY 1.0
chkpass_16
PIGSTY 1.0
chkpass_15
PIGSTY 1.0
chkpass_14
PIGSTY 1.0
chkpass_13
PIGSTY 1.0
el9 x86_64 chkpass_17
PIGSTY 1.0
chkpass_16
PIGSTY 1.0
chkpass_15
PIGSTY 1.0
chkpass_14
PIGSTY 1.0
chkpass_13
PIGSTY 1.0
el9 aarch64 chkpass_17
PIGSTY 1.0
chkpass_16
PIGSTY 1.0
chkpass_15
PIGSTY 1.0
chkpass_14
PIGSTY 1.0
chkpass_13
PIGSTY 1.0
d12 x86_64 postgresql-17-chkpass
PIGSTY 1.0
postgresql-16-chkpass
PIGSTY 1.0
postgresql-15-chkpass
PIGSTY 1.0
postgresql-14-chkpass
PIGSTY 1.0
postgresql-13-chkpass
PIGSTY 1.0
d12 aarch64 postgresql-17-chkpass
PIGSTY 1.0
postgresql-16-chkpass
PIGSTY 1.0
postgresql-15-chkpass
PIGSTY 1.0
postgresql-14-chkpass
PIGSTY 1.0
postgresql-13-chkpass
PIGSTY 1.0
u22 x86_64 postgresql-17-chkpass
PIGSTY 1.0
postgresql-16-chkpass
PIGSTY 1.0
postgresql-15-chkpass
PIGSTY 1.0
postgresql-14-chkpass
PIGSTY 1.0
postgresql-13-chkpass
PIGSTY 1.0
u22 aarch64 postgresql-17-chkpass
PIGSTY 1.0
postgresql-16-chkpass
PIGSTY 1.0
postgresql-15-chkpass
PIGSTY 1.0
postgresql-14-chkpass
PIGSTY 1.0
postgresql-13-chkpass
PIGSTY 1.0
u24 x86_64 postgresql-17-chkpass
PIGSTY 1.0
postgresql-16-chkpass
PIGSTY 1.0
postgresql-15-chkpass
PIGSTY 1.0
postgresql-14-chkpass
PIGSTY 1.0
postgresql-13-chkpass
PIGSTY 1.0
u24 aarch64 postgresql-17-chkpass
PIGSTY 1.0
postgresql-16-chkpass
PIGSTY 1.0
postgresql-15-chkpass
PIGSTY 1.0
postgresql-14-chkpass
PIGSTY 1.0
postgresql-13-chkpass
PIGSTY 1.0

Installation

Install chkpass via the pig CLI tool:

pig ext install chkpass

Install chkpass via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["chkpass"]}' # -l <cls>

Install chkpass RPM from YUM repo directly:

dnf install chkpass_17*;
dnf install chkpass_16*;
dnf install chkpass_15*;
dnf install chkpass_14*;
dnf install chkpass_13*;

Install chkpass DEB from APT repo directly:

apt install postgresql-17-chkpass;
apt install postgresql-16-chkpass;
apt install postgresql-15-chkpass;
apt install postgresql-14-chkpass;
apt install postgresql-13-chkpass;

Enable chkpass extension on PostgreSQL cluster:

CREATE EXTENSION chkpass;



29 - isn

data types for international product numbering standards

Overview

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

Information

Metadata

  • Latest Version: 1.2
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension


Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64
d12 aarch64
u22 x86_64
u22 aarch64
u24 x86_64
u24 aarch64

Installation

Extension isn is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install isn RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install isn DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Enable isn extension on PostgreSQL cluster:

CREATE EXTENSION isn;



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

  • Latest Version: 1.4
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension


Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64
d12 aarch64
u22 x86_64
u22 aarch64
u24 x86_64
u24 aarch64

Installation

Extension seg is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install seg RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install seg DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Enable seg extension on PostgreSQL cluster:

CREATE EXTENSION seg;



31 - cube

data type for multidimensional cubes

Overview

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

Information

Metadata

  • Latest Version: 1.5
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension


Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64
d12 aarch64
u22 x86_64
u22 aarch64
u24 x86_64
u24 aarch64

Installation

Extension cube is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install cube RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install cube DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Enable cube extension on PostgreSQL cluster:

CREATE EXTENSION cube;



32 - ltree

data type for hierarchical tree-like structures

Overview

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

Information

Metadata

  • Latest Version: 1.3
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension


Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64
d12 aarch64
u22 x86_64
u22 aarch64
u24 x86_64
u24 aarch64

Installation

Extension ltree is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install ltree RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install ltree DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Enable ltree extension on PostgreSQL cluster:

CREATE EXTENSION ltree;



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

  • Latest Version: 1.8
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension


Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64
d12 aarch64
u22 x86_64
u22 aarch64
u24 x86_64
u24 aarch64

Installation

Extension hstore is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install hstore RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install hstore DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Enable hstore extension on PostgreSQL cluster:

CREATE EXTENSION hstore;



34 - citext

data type for case-insensitive character strings

Overview

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

Information

Metadata

  • Latest Version: 1.6
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension


Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64
d12 aarch64
u22 x86_64
u22 aarch64
u24 x86_64
u24 aarch64

Installation

Extension citext is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install citext RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install citext DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Enable citext extension on PostgreSQL cluster:

CREATE EXTENSION citext;



35 - xml2

XPath querying and XSLT

Overview

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

Information

Metadata

  • Latest Version: 1.1
  • Postgres Support: 17,16,15,14,13
  • Need Load: Shared library do not need explicit loading
  • Need DDL: Need CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension


Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64
el8 aarch64
el9 x86_64
el9 aarch64
d12 x86_64
d12 aarch64
u22 x86_64
u22 aarch64
u24 x86_64
u24 aarch64

Installation

Extension xml2 is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install xml2 RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install xml2 DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Enable xml2 extension on PostgreSQL cluster:

CREATE EXTENSION xml2;