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:
1 - prefix
Prefix Range module for PostgreSQL
Overview
PGDG 1st Party Extension: pg_prefix
: Prefix Range module for PostgreSQL
- 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
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:
2 - semver
Semantic version data type
Overview
PGDG 1st Party Extension: pg_semver
: Semantic version data type
- 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
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:
3 - unit
SI units extension
Overview
PGDG 1st Party Extension: pgunit
: SI units extension
- 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
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
- 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
Installation
Install pgpdf
via the pig
CLI tool:
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:
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);
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:
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
- 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
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:
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
- 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
Installation
Install md5hash
via the pig
CLI tool:
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
- 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
Installation
Install asn1oid
via the pig
CLI tool:
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
- 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
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
- 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
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
- 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
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
- 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
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.
- 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
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
- 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
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
- 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
Installation
Install pgmp
via the pig
CLI tool:
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:
15 - numeral
numeral datatypes extension
Overview
MIXED 3rd Party Extension: numeral
: numeral datatypes extension
- 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
Installation
Install numeral
via the pig
CLI tool:
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
- 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
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
- 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
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:
18 - uint128
Native uint128 type
Overview
PIGSTY 3rd Party Extension: pg_uint128
: Native uint128 type
- 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
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
- 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
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
- 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
Installation
Install ip4r
via the pig
CLI tool:
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:
21 - pg_duration
data type for representing durations
Overview
PIGSTY 3rd Party Extension: pg_duration
: data type for representing durations
- 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
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
- 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
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:
23 - emailaddr
Email address type for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pgemailaddr
: Email address type for PostgreSQL
- 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
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
- 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
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:
25 - debversion
Debian version number data type
Overview
PGDG 1st Party Extension: debversion
: Debian version number data type
- 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
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
- 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
Installation
Install pg_rrule
via the pig
CLI tool:
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
- 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
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
- 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
Installation
Install chkpass
via the pig
CLI tool:
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
- 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:
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
- 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:
31 - cube
data type for multidimensional cubes
Overview
CONTRIB Built-in Extension: cube
: data type for multidimensional cubes
- 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:
32 - ltree
data type for hierarchical tree-like structures
Overview
CONTRIB Built-in Extension: ltree
: data type for hierarchical tree-like structures
- 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:
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
- 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:
34 - citext
data type for case-insensitive character strings
Overview
CONTRIB Built-in Extension: citext
: data type for case-insensitive character strings
- 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:
35 - xml2
XPath querying and XSLT
Overview
CONTRIB Built-in Extension: xml2
: XPath querying and XSLT
- 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: