This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
Category: FUNC
FUNC: Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…
FUNC category has 41 available extensions:
1 - pg_idkit
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
Overview
PIGSTY 3rd Party Extension: pg_idkit : multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
- Latest Version: 0.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 be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_idkit_$v
- RPM Ver :
0.2.4
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-idkit
- DEB Ver :
0.2.4
- DEB Deps: N/A
Packages
Installation
Install pg_idkit via the pig CLI tool:
Install pg_idkit via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_idkit"]}' # -l <cls>
Install pg_idkit RPM from YUM repo directly:
dnf install pg_idkit_17;
dnf install pg_idkit_16;
dnf install pg_idkit_15;
dnf install pg_idkit_14;
dnf install pg_idkit_13;
Install pg_idkit DEB from APT repo directly:
apt install postgresql-17-pg-idkit;
apt install postgresql-16-pg-idkit;
apt install postgresql-15-pg-idkit;
apt install postgresql-14-pg-idkit;
apt install postgresql-13-pg-idkit;
Enable pg_idkit extension on PostgreSQL cluster：
CREATE EXTENSION pg_idkit;
2 - pg_uuidv7
pg_uuidv7: create UUIDv7 values in postgres
Overview
MIXED 3rd Party Extension: pg_uuidv7 : pg_uuidv7: create UUIDv7 values in postgres
- 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: 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:
pg_uuidv7_$v*
- RPM Ver :
1.6
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-uuidv7
- DEB Ver :
1.6
- DEB Deps: N/A
Packages
Installation
Install pg_uuidv7 via the pig CLI tool:
pig ext install pg_uuidv7
Install pg_uuidv7 via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_uuidv7"]}' # -l <cls>
Install pg_uuidv7 RPM from YUM repo directly:
dnf install pg_uuidv7_17*;
dnf install pg_uuidv7_16*;
dnf install pg_uuidv7_15*;
dnf install pg_uuidv7_14*;
dnf install pg_uuidv7_13*;
Install pg_uuidv7 DEB from APT repo directly:
apt install postgresql-17-pg-uuidv7;
apt install postgresql-16-pg-uuidv7;
apt install postgresql-15-pg-uuidv7;
apt install postgresql-14-pg-uuidv7;
apt install postgresql-13-pg-uuidv7;
Enable pg_uuidv7 extension on PostgreSQL cluster：
CREATE EXTENSION pg_uuidv7;
3 - permuteseq
Pseudo-randomly permute sequences with a format-preserving encryption on elements
Overview
PIGSTY 3rd Party Extension: permuteseq : Pseudo-randomly permute sequences with a format-preserving encryption on elements
- 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: PIGSTY
- RPM Name:
permuteseq_$v*
- RPM Ver :
1.2
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-permuteseq
- DEB Ver :
1.2
- DEB Deps: N/A
Packages
Installation
Install permuteseq via the pig CLI tool:
pig ext install permuteseq
Install permuteseq via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["permuteseq"]}' # -l <cls>
Install permuteseq RPM from YUM repo directly:
dnf install permuteseq_17*;
dnf install permuteseq_16*;
dnf install permuteseq_15*;
dnf install permuteseq_14*;
dnf install permuteseq_13*;
Install permuteseq DEB from APT repo directly:
apt install postgresql-17-permuteseq;
apt install postgresql-16-permuteseq;
apt install postgresql-15-permuteseq;
apt install postgresql-14-permuteseq;
apt install postgresql-13-permuteseq;
Enable permuteseq extension on PostgreSQL cluster：
CREATE EXTENSION permuteseq;
4 - pg_hashids
Short unique id generator for PostgreSQL, using hashids
Overview
PIGSTY 3rd Party Extension: pg_hashids : Short unique id generator for PostgreSQL, using hashids
- 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: 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_hashids_$v*
- RPM Ver :
1.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-hashids
- DEB Ver :
1.3
- DEB Deps: N/A
Packages
Installation
Install pg_hashids via the pig CLI tool:
pig ext install pg_hashids
Install pg_hashids via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_hashids"]}' # -l <cls>
Install pg_hashids RPM from YUM repo directly:
dnf install pg_hashids_17*;
dnf install pg_hashids_16*;
dnf install pg_hashids_15*;
dnf install pg_hashids_14*;
dnf install pg_hashids_13*;
Install pg_hashids DEB from APT repo directly:
apt install postgresql-17-pg-hashids;
apt install postgresql-16-pg-hashids;
apt install postgresql-15-pg-hashids;
apt install postgresql-14-pg-hashids;
apt install postgresql-13-pg-hashids;
Enable pg_hashids extension on PostgreSQL cluster：
CREATE EXTENSION pg_hashids;
5 - sequential_uuids
generator of sequential UUIDs
Overview
MIXED 3rd Party Extension: sequential_uuids : generator of sequential UUIDs
- Latest Version: 1.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: PGDG
- RPM Name:
sequential_uuids_$v
- RPM Ver :
1.0.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-sequential-uuids
- DEB Ver :
1.0.3
- DEB Deps: N/A
Packages
Installation
Install sequential_uuids via the pig CLI tool:
pig ext install sequential_uuids
Install sequential_uuids via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["sequential_uuids"]}' # -l <cls>
Install sequential_uuids RPM from YUM repo directly:
dnf install sequential_uuids_17;
dnf install sequential_uuids_16;
dnf install sequential_uuids_15;
dnf install sequential_uuids_14;
dnf install sequential_uuids_13;
Install sequential_uuids DEB from APT repo directly:
apt install postgresql-17-sequential-uuids;
apt install postgresql-16-sequential-uuids;
apt install postgresql-15-sequential-uuids;
apt install postgresql-14-sequential-uuids;
apt install postgresql-13-sequential-uuids;
Enable sequential_uuids extension on PostgreSQL cluster：
CREATE EXTENSION sequential_uuids;
6 - topn
type for top-n JSONB
Overview
PGDG 3rd Party Extension: topn : type for top-n JSONB
- Latest Version: 2.7.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:
topn_$v*
- RPM Ver :
2.7.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-topn
- DEB Ver :
2.7.0
- DEB Deps: N/A
Packages
Installation
Install topn via the pig CLI tool:
Install topn via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["topn"]}' # -l <cls>
Install topn RPM from YUM repo directly:
dnf install topn_17*;
dnf install topn_16*;
dnf install topn_15*;
dnf install topn_14*;
dnf install topn_13*;
Install topn DEB from APT repo directly:
apt install postgresql-17-topn;
apt install postgresql-16-topn;
apt install postgresql-15-topn;
apt install postgresql-14-topn;
apt install postgresql-13-topn;
Enable topn extension on PostgreSQL cluster：
7 - quantile
Quantile aggregation function
Overview
PIGSTY 3rd Party Extension: quantile : Quantile aggregation function
- Latest Version: 1.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: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
quantile_$v*
- RPM Ver :
1.1.8
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-quantile
- DEB Ver :
1.1.8
- DEB Deps: N/A
Packages
Installation
Install quantile via the pig CLI tool:
Install quantile via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["quantile"]}' # -l <cls>
Install quantile RPM from YUM repo directly:
dnf install quantile_17*;
dnf install quantile_16*;
dnf install quantile_15*;
dnf install quantile_14*;
dnf install quantile_13*;
Install quantile DEB from APT repo directly:
apt install postgresql-17-quantile;
apt install postgresql-16-quantile;
apt install postgresql-15-quantile;
apt install postgresql-14-quantile;
apt install postgresql-13-quantile;
Enable quantile extension on PostgreSQL cluster：
CREATE EXTENSION quantile;
8 - lower_quantile
Lower quantile aggregate function
Overview
PIGSTY 3rd Party Extension: lower_quantile : Lower quantile aggregate function
- Latest Version: 1.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: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
lower_quantile_$v*
- RPM Ver :
1.0.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-lower-quantile
- DEB Ver :
1.0.3
- DEB Deps: N/A
Packages
Installation
Install lower_quantile via the pig CLI tool:
pig ext install lower_quantile
Install lower_quantile via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["lower_quantile"]}' # -l <cls>
Install lower_quantile RPM from YUM repo directly:
dnf install lower_quantile_17*;
dnf install lower_quantile_16*;
dnf install lower_quantile_15*;
dnf install lower_quantile_14*;
dnf install lower_quantile_13*;
Install lower_quantile DEB from APT repo directly:
apt install postgresql-17-lower-quantile;
apt install postgresql-16-lower-quantile;
apt install postgresql-15-lower-quantile;
apt install postgresql-14-lower-quantile;
apt install postgresql-13-lower-quantile;
Enable lower_quantile extension on PostgreSQL cluster：
CREATE EXTENSION lower_quantile;
9 - count_distinct
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
Overview
MIXED 3rd Party Extension: count_distinct : An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
- Latest Version: 3.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: 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:
count_distinct_$v*
- RPM Ver :
3.0.2
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-count-distinct
- DEB Ver :
3.0.2
- DEB Deps: N/A
Packages
Installation
Install count_distinct via the pig CLI tool:
pig ext install count_distinct
Install count_distinct via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["count_distinct"]}' # -l <cls>
Install count_distinct RPM from YUM repo directly:
dnf install count_distinct_17*;
dnf install count_distinct_16*;
dnf install count_distinct_15*;
dnf install count_distinct_14*;
dnf install count_distinct_13*;
Install count_distinct DEB from APT repo directly:
apt install postgresql-17-count-distinct;
apt install postgresql-16-count-distinct;
apt install postgresql-15-count-distinct;
apt install postgresql-14-count-distinct;
apt install postgresql-13-count-distinct;
Enable count_distinct extension on PostgreSQL cluster：
CREATE EXTENSION count_distinct;
10 - omnisketch
data structure for on-line agg of data into approximate sketch
Overview
PIGSTY 3rd Party Extension: omnisketch : data structure for on-line agg of data into approximate sketch
- 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:
omnisketch_$v*
- RPM Ver :
1.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-omnisketch
- DEB Ver :
1.0.1
- DEB Deps: N/A
Packages
Installation
Install omnisketch via the pig CLI tool:
pig ext install omnisketch
Install omnisketch via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["omnisketch"]}' # -l <cls>
Install omnisketch RPM from YUM repo directly:
dnf install omnisketch_17*;
dnf install omnisketch_16*;
dnf install omnisketch_15*;
dnf install omnisketch_14*;
dnf install omnisketch_13*;
Install omnisketch DEB from APT repo directly:
apt install postgresql-17-omnisketch;
apt install postgresql-16-omnisketch;
apt install postgresql-15-omnisketch;
apt install postgresql-14-omnisketch;
apt install postgresql-13-omnisketch;
Enable omnisketch extension on PostgreSQL cluster：
CREATE EXTENSION omnisketch;
11 - ddsketch
Provides ddsketch aggregate function
Overview
PIGSTY 3rd Party Extension: ddsketch : Provides ddsketch aggregate function
- 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:
ddsketch_$v*
- RPM Ver :
1.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-ddsketch
- DEB Ver :
1.0.1
- DEB Deps: N/A
Packages
Installation
Install ddsketch via the pig CLI tool:
Install ddsketch via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["ddsketch"]}' # -l <cls>
Install ddsketch RPM from YUM repo directly:
dnf install ddsketch_17*;
dnf install ddsketch_16*;
dnf install ddsketch_15*;
dnf install ddsketch_14*;
dnf install ddsketch_13*;
Install ddsketch DEB from APT repo directly:
apt install postgresql-17-ddsketch;
apt install postgresql-16-ddsketch;
apt install postgresql-15-ddsketch;
apt install postgresql-14-ddsketch;
apt install postgresql-13-ddsketch;
Enable ddsketch extension on PostgreSQL cluster：
CREATE EXTENSION ddsketch;
12 - vasco
discover hidden correlations in your data with MIC
Overview
PIGSTY 3rd Party Extension: vasco : discover hidden correlations in your data with MIC
- Latest Version: 0.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: 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:
vasco_$v*
- RPM Ver :
0.1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-vasco
- DEB Ver :
0.1.0
- DEB Deps: N/A
Packages
Installation
Install vasco via the pig CLI tool:
Install vasco via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["vasco"]}' # -l <cls>
Install vasco RPM from YUM repo directly:
dnf install vasco_17*;
dnf install vasco_16*;
dnf install vasco_15*;
dnf install vasco_14*;
dnf install vasco_13*;
Install vasco DEB from APT repo directly:
apt install postgresql-17-vasco;
apt install postgresql-16-vasco;
apt install postgresql-15-vasco;
apt install postgresql-14-vasco;
apt install postgresql-13-vasco;
Enable vasco extension on PostgreSQL cluster：
13 - xicor
XI Correlation Coefficient in Postgres
Overview
PIGSTY 3rd Party Extension: pgxicor : XI Correlation Coefficient in Postgres
- Latest Version: 0.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: 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:
pgxicor_$v*
- RPM Ver :
0.1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgxicor
- DEB Ver :
0.1.0
- DEB Deps: N/A
Packages
Installation
Install xicor via the pig CLI tool:
pig ext install pgxicor; # Extension Namepig ext install xicor; # normalized package name
Install pgxicor via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgxicor"]}' # -l <cls>
Install pgxicor RPM from YUM repo directly:
dnf install pgxicor_17*;
dnf install pgxicor_16*;
dnf install pgxicor_15*;
dnf install pgxicor_14*;
dnf install pgxicor_13*;
Install pgxicor DEB from APT repo directly:
apt install postgresql-17-pgxicor;
apt install postgresql-16-pgxicor;
apt install postgresql-15-pgxicor;
apt install postgresql-14-pgxicor;
apt install postgresql-13-pgxicor;
Enable xicor extension on PostgreSQL cluster：
14 - tdigest
Provides tdigest aggregate function.
Overview
PGDG 1st Party Extension: tdigest : Provides tdigest aggregate function.
- Latest Version: 1.4.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: PGDG
- RPM Name:
tdigest_$v*
- RPM Ver :
1.4.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-tdigest
- DEB Ver :
1.4.3
- DEB Deps: N/A
Packages
Installation
Install tdigest via the pig CLI tool:
Install tdigest via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["tdigest"]}' # -l <cls>
Install tdigest RPM from YUM repo directly:
dnf install tdigest_17*;
dnf install tdigest_16*;
dnf install tdigest_15*;
dnf install tdigest_14*;
dnf install tdigest_13*;
Install tdigest DEB from APT repo directly:
apt install postgresql-17-tdigest;
apt install postgresql-16-tdigest;
apt install postgresql-15-tdigest;
apt install postgresql-14-tdigest;
apt install postgresql-13-tdigest;
Enable tdigest extension on PostgreSQL cluster：
CREATE EXTENSION tdigest;
15 - first_last_agg
first() and last() aggregate functions
Overview
MIXED 3rd Party Extension: first_last_agg : first() and last() aggregate functions
- Latest Version: 0.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: 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:
first_last_agg_$v
- RPM Ver :
0.1.4
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-first-last-agg
- DEB Ver :
0.1.4
- DEB Deps: N/A
Packages
Installation
Install first_last_agg via the pig CLI tool:
pig ext install first_last_agg
Install first_last_agg via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["first_last_agg"]}' # -l <cls>
Install first_last_agg RPM from YUM repo directly:
dnf install first_last_agg_17;
dnf install first_last_agg_16;
dnf install first_last_agg_15;
dnf install first_last_agg_14;
dnf install first_last_agg_13;
Install first_last_agg DEB from APT repo directly:
apt install postgresql-17-first-last-agg;
apt install postgresql-16-first-last-agg;
apt install postgresql-15-first-last-agg;
apt install postgresql-14-first-last-agg;
apt install postgresql-13-first-last-agg;
Enable first_last_agg extension on PostgreSQL cluster：
CREATE EXTENSION first_last_agg;
16 - extra_window_functions
Extra Window Functions for PostgreSQL
Overview
PGDG 1st Party Extension: extra_window_functions : Extra Window Functions for PostgreSQL
- 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: 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:
extra_window_functions_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-extra-window-functions
- DEB Ver :
1.0
- DEB Deps: N/A
Packages
Installation
Install extra_window_functions via the pig CLI tool:
pig ext install extra_window_functions
Install extra_window_functions via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["extra_window_functions"]}' # -l <cls>
Install extra_window_functions RPM from YUM repo directly:
dnf install extra_window_functions_17*;
dnf install extra_window_functions_16*;
dnf install extra_window_functions_15*;
Install extra_window_functions DEB from APT repo directly:
apt install postgresql-17-extra-window-functions;
apt install postgresql-16-extra-window-functions;
apt install postgresql-15-extra-window-functions;
apt install postgresql-14-extra-window-functions;
apt install postgresql-13-extra-window-functions;
Enable extra_window_functions extension on PostgreSQL cluster：
CREATE EXTENSION extra_window_functions;
17 - floatvec
Math for vectors (arrays) of numbers
Overview
PIGSTY 3rd Party Extension: floatvec : Math for vectors (arrays) of numbers
- Latest Version: 1.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: PIGSTY
- RPM Name:
floatvec_$v*
- RPM Ver :
1.1.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-floatvec
- DEB Ver :
1.1.1
- DEB Deps: N/A
Packages
Installation
Install floatvec via the pig CLI tool:
Install floatvec via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["floatvec"]}' # -l <cls>
Install floatvec RPM from YUM repo directly:
dnf install floatvec_17*;
dnf install floatvec_16*;
dnf install floatvec_15*;
dnf install floatvec_14*;
dnf install floatvec_13*;
Install floatvec DEB from APT repo directly:
apt install postgresql-17-floatvec;
apt install postgresql-16-floatvec;
apt install postgresql-15-floatvec;
apt install postgresql-14-floatvec;
apt install postgresql-13-floatvec;
Enable floatvec extension on PostgreSQL cluster：
CREATE EXTENSION floatvec;
18 - aggs_for_vecs
Aggregate functions for array inputs
Overview
PIGSTY 3rd Party Extension: aggs_for_vecs : Aggregate functions for array inputs
- Latest Version: 1.3.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: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
aggs_for_vecs_$v*
- RPM Ver :
1.3.2
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-aggs-for-vecs
- DEB Ver :
1.3.2
- DEB Deps: N/A
Packages
Installation
Install aggs_for_vecs via the pig CLI tool:
pig ext install aggs_for_vecs
Install aggs_for_vecs via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["aggs_for_vecs"]}' # -l <cls>
Install aggs_for_vecs RPM from YUM repo directly:
dnf install aggs_for_vecs_17*;
dnf install aggs_for_vecs_16*;
dnf install aggs_for_vecs_15*;
dnf install aggs_for_vecs_14*;
dnf install aggs_for_vecs_13*;
Install aggs_for_vecs DEB from APT repo directly:
apt install postgresql-17-aggs-for-vecs;
apt install postgresql-16-aggs-for-vecs;
apt install postgresql-15-aggs-for-vecs;
apt install postgresql-14-aggs-for-vecs;
apt install postgresql-13-aggs-for-vecs;
Enable aggs_for_vecs extension on PostgreSQL cluster：
CREATE EXTENSION aggs_for_vecs;
19 - aggs_for_arrays
Various functions for computing statistics on arrays of numbers
Overview
PIGSTY 3rd Party Extension: aggs_for_arrays : Various functions for computing statistics on arrays of numbers
- Latest Version: 1.3.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:
aggs_for_arrays_$v*
- RPM Ver :
1.3.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-aggs-for-arrays
- DEB Ver :
1.3.3
- DEB Deps: N/A
Packages
Installation
Install aggs_for_arrays via the pig CLI tool:
pig ext install aggs_for_arrays
Install aggs_for_arrays via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["aggs_for_arrays"]}' # -l <cls>
Install aggs_for_arrays RPM from YUM repo directly:
dnf install aggs_for_arrays_17*;
dnf install aggs_for_arrays_16*;
dnf install aggs_for_arrays_15*;
dnf install aggs_for_arrays_14*;
dnf install aggs_for_arrays_13*;
Install aggs_for_arrays DEB from APT repo directly:
apt install postgresql-17-aggs-for-arrays;
apt install postgresql-16-aggs-for-arrays;
apt install postgresql-15-aggs-for-arrays;
apt install postgresql-14-aggs-for-arrays;
apt install postgresql-13-aggs-for-arrays;
Enable aggs_for_arrays extension on PostgreSQL cluster：
CREATE EXTENSION aggs_for_arrays;
20 - arraymath
Array math and operators that work element by element on the contents of arrays
Overview
PIGSTY 3rd Party Extension: pg_arraymath : Array math and operators that work element by element on the contents of arrays
- 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: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_arraymath_$v*
- RPM Ver :
1.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-arraymath
- DEB Ver :
1.1
- DEB Deps: N/A
Packages
Installation
Install arraymath via the pig CLI tool:
pig ext install pg_arraymath; # Extension Namepig ext install arraymath; # normalized package name
Install pg_arraymath via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_arraymath"]}' # -l <cls>
Install pg_arraymath RPM from YUM repo directly:
dnf install pg_arraymath_17*;
dnf install pg_arraymath_16*;
dnf install pg_arraymath_15*;
dnf install pg_arraymath_14*;
dnf install pg_arraymath_13*;
Install pg_arraymath DEB from APT repo directly:
apt install postgresql-17-pg-arraymath;
apt install postgresql-16-pg-arraymath;
apt install postgresql-15-pg-arraymath;
apt install postgresql-14-pg-arraymath;
apt install postgresql-13-pg-arraymath;
Enable arraymath extension on PostgreSQL cluster：
CREATE EXTENSION arraymath;
21 - pg_math
GSL statistical functions for postgresql
Overview
PIGSTY 3rd Party Extension: pg_math : GSL statistical functions for postgresql
- 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: Can not install to arbitrary schema
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_math_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-math
- DEB Ver :
1.0
- DEB Deps: N/A
Packages
Installation
Install pg_math via the pig CLI tool:
Install pg_math via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_math"]}' # -l <cls>
Install pg_math RPM from YUM repo directly:
dnf install pg_math_17*;
dnf install pg_math_16*;
dnf install pg_math_15*;
dnf install pg_math_14*;
dnf install pg_math_13*;
Install pg_math DEB from APT repo directly:
apt install postgresql-17-pg-math;
apt install postgresql-16-pg-math;
apt install postgresql-15-pg-math;
apt install postgresql-14-pg-math;
apt install postgresql-13-pg-math;
Enable pg_math extension on PostgreSQL cluster：
CREATE EXTENSION pg_math;
22 - random
random data generator
Overview
PIGSTY 3rd Party Extension: pg_random : random data generator
- Latest Version: 2.0.0-dev
- 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_random_$v*
- RPM Ver :
2.0.0-dev
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-random
- DEB Ver :
2.0.0-dev
- DEB Deps: N/A
Packages
Installation
Install random via the pig CLI tool:
pig ext install pg_random; # Extension Namepig ext install random; # normalized package name
Install pg_random via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_random"]}' # -l <cls>
Install pg_random RPM from YUM repo directly:
dnf install pg_random_17*;
dnf install pg_random_16*;
dnf install pg_random_15*;
dnf install pg_random_14*;
dnf install pg_random_13*;
Install pg_random DEB from APT repo directly:
apt install postgresql-17-random;
apt install postgresql-16-random;
apt install postgresql-15-random;
apt install postgresql-14-random;
apt install postgresql-13-random;
Enable random extension on PostgreSQL cluster：
23 - base36
Integer Base36 types
Overview
PIGSTY 3rd Party Extension: pg_base36 : Integer Base36 types
- 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: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_base36_$v*
- RPM Ver :
1.0.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-base36
- DEB Ver :
1.0.0
- DEB Deps: N/A
Packages
Installation
Install base36 via the pig CLI tool:
pig ext install pg_base36; # Extension Namepig ext install base36; # normalized package name
Install pg_base36 via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_base36"]}' # -l <cls>
Install pg_base36 RPM from YUM repo directly:
dnf install pg_base36_17*;
dnf install pg_base36_16*;
dnf install pg_base36_15*;
dnf install pg_base36_14*;
dnf install pg_base36_13*;
Install pg_base36 DEB from APT repo directly:
apt install postgresql-17-base36;
apt install postgresql-16-base36;
apt install postgresql-15-base36;
apt install postgresql-14-base36;
apt install postgresql-13-base36;
Enable base36 extension on PostgreSQL cluster：
24 - base62
Base62 extension for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pg_base62 : Base62 extension for PostgreSQL
- Latest Version: 0.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: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_base62_$v*
- RPM Ver :
0.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-base62
- DEB Ver :
0.0.1
- DEB Deps: N/A
Packages
Installation
Install base62 via the pig CLI tool:
pig ext install pg_base62; # Extension Namepig ext install base62; # normalized package name
Install pg_base62 via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_base62"]}' # -l <cls>
Install pg_base62 RPM from YUM repo directly:
dnf install pg_base62_17*;
dnf install pg_base62_16*;
dnf install pg_base62_15*;
dnf install pg_base62_14*;
dnf install pg_base62_13*;
Install pg_base62 DEB from APT repo directly:
apt install postgresql-17-base62;
apt install postgresql-16-base62;
apt install postgresql-15-base62;
apt install postgresql-14-base62;
apt install postgresql-13-base62;
Enable base62 extension on PostgreSQL cluster：
25 - pg_base58
Base58 Encoder/Decoder Extension for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pg_base58 : Base58 Encoder/Decoder Extension for PostgreSQL
- Latest Version: 0.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 be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_base58_$v
- RPM Ver :
0.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-base58
- DEB Ver :
0.0.1
- DEB Deps: N/A
Packages
Installation
Install pg_base58 via the pig CLI tool:
pig ext install pg_base58
Install pg_base58 via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_base58"]}' # -l <cls>
Install pg_base58 RPM from YUM repo directly:
dnf install pg_base58_17;
dnf install pg_base58_16;
dnf install pg_base58_15;
dnf install pg_base58_14;
dnf install pg_base58_13;
Install pg_base58 DEB from APT repo directly:
apt install postgresql-17-pg-base58;
apt install postgresql-16-pg-base58;
apt install postgresql-15-pg-base58;
apt install postgresql-14-pg-base58;
apt install postgresql-13-pg-base58;
Enable pg_base58 extension on PostgreSQL cluster：
CREATE EXTENSION pg_base58;
26 - financial
Financial aggregate functions
Overview
PIGSTY 3rd Party Extension: pg_financial : Financial aggregate functions
- 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: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_financial_$v*
- RPM Ver :
1.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-financial
- DEB Ver :
1.0.1
- DEB Deps: N/A
Packages
Installation
Install financial via the pig CLI tool:
pig ext install pg_financial; # Extension Namepig ext install financial; # normalized package name
Install pg_financial via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_financial"]}' # -l <cls>
Install pg_financial RPM from YUM repo directly:
dnf install pg_financial_17*;
dnf install pg_financial_16*;
dnf install pg_financial_15*;
dnf install pg_financial_14*;
dnf install pg_financial_13*;
Install pg_financial DEB from APT repo directly:
apt install postgresql-17-pg-financial;
apt install postgresql-16-pg-financial;
apt install postgresql-15-pg-financial;
apt install postgresql-14-pg-financial;
apt install postgresql-13-pg-financial;
Enable financial extension on PostgreSQL cluster：
CREATE EXTENSION financial;
27 - refint
functions for implementing referential integrity (obsolete)
Overview
CONTRIB Built-in Extension: refint : functions for implementing referential integrity (obsolete)
- 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: 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 refint is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install refint 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 refint 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 refint extension on PostgreSQL cluster：
28 - autoinc
functions for autoincrementing fields
Overview
CONTRIB Built-in Extension: autoinc : functions for autoincrementing fields
- 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: 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 autoinc is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install autoinc 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 autoinc 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 autoinc extension on PostgreSQL cluster：
CREATE EXTENSION autoinc;
29 - insert_username
functions for tracking who changed a table
Overview
CONTRIB Built-in Extension: insert_username : functions for tracking who changed a table
- 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: 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 insert_username is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install insert_username 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 insert_username 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 insert_username extension on PostgreSQL cluster：
CREATE EXTENSION insert_username;
30 - moddatetime
functions for tracking last modification time
Overview
CONTRIB Built-in Extension: moddatetime : functions for tracking last modification time
- 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: 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 moddatetime is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install moddatetime 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 moddatetime 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 moddatetime extension on PostgreSQL cluster：
CREATE EXTENSION moddatetime;
31 - tsm_system_time
TABLESAMPLE method which accepts time in milliseconds as a limit
Overview
CONTRIB Built-in Extension: tsm_system_time : TABLESAMPLE method which accepts time in milliseconds as a limit
- 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: 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 tsm_system_time is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install tsm_system_time 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 tsm_system_time 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 tsm_system_time extension on PostgreSQL cluster：
CREATE EXTENSION tsm_system_time;
32 - dict_xsyn
text search dictionary template for extended synonym processing
Overview
CONTRIB Built-in Extension: dict_xsyn : text search dictionary template for extended synonym processing
- 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: 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 dict_xsyn is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install dict_xsyn 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 dict_xsyn 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 dict_xsyn extension on PostgreSQL cluster：
CREATE EXTENSION dict_xsyn;
33 - tsm_system_rows
TABLESAMPLE method which accepts number of rows as a limit
Overview
CONTRIB Built-in Extension: tsm_system_rows : TABLESAMPLE method which accepts number of rows as a limit
- 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: 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 tsm_system_rows is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install tsm_system_rows 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 tsm_system_rows 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 tsm_system_rows extension on PostgreSQL cluster：
CREATE EXTENSION tsm_system_rows;
34 - tcn
Triggered change notifications
Overview
CONTRIB Built-in Extension: tcn : Triggered change notifications
- 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: 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 tcn is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install tcn 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 tcn 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 tcn extension on PostgreSQL cluster：
35 - uuid-ossp
generate universally unique identifiers (UUIDs)
Overview
CONTRIB Built-in Extension: uuid-ossp : generate universally unique identifiers (UUIDs)
- 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: 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 uuid-ossp is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install uuid-ossp 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 uuid-ossp 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 uuid-ossp extension on PostgreSQL cluster：
CREATE EXTENSION "uuid-ossp";
36 - uuid-ossp
generate universally unique identifiers (UUIDs)
Overview
CONTRIB Built-in Extension: uuid-ossp : generate universally unique identifiers (UUIDs)
- 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: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
37 - btree_gist
support for indexing common datatypes in GiST
Overview
CONTRIB Built-in Extension: btree_gist : support for indexing common datatypes in GiST
- Latest Version: 1.7
- 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 btree_gist is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install btree_gist 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 btree_gist 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 btree_gist extension on PostgreSQL cluster：
CREATE EXTENSION btree_gist;
38 - btree_gin
support for indexing common datatypes in GIN
Overview
CONTRIB Built-in Extension: btree_gin : support for indexing common datatypes in GIN
- 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 btree_gin is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install btree_gin 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 btree_gin 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 btree_gin extension on PostgreSQL cluster：
CREATE EXTENSION btree_gin;
39 - intarray
functions, operators, and index support for 1-D arrays of integers
Overview
CONTRIB Built-in Extension: intarray : functions, operators, and index support for 1-D arrays of integers
- 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: 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 intarray is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install intarray 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 intarray 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 intarray extension on PostgreSQL cluster：
CREATE EXTENSION intarray;
40 - intagg
integer aggregator and enumerator (obsolete)
Overview
CONTRIB Built-in Extension: intagg : integer aggregator and enumerator (obsolete)
- 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 intagg is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install intagg 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 intagg 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 intagg extension on PostgreSQL cluster：
41 - dict_int
text search dictionary template for integers
Overview
CONTRIB Built-in Extension: dict_int : text search dictionary template for integers
- 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: 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 dict_int is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install dict_int 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 dict_int 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 dict_int extension on PostgreSQL cluster：
CREATE EXTENSION dict_int;
42 - unaccent
text search dictionary that removes accents
Overview
CONTRIB Built-in Extension: unaccent : text search dictionary that removes accents
- 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: 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 unaccent is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install unaccent 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 unaccent 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 unaccent extension on PostgreSQL cluster：
CREATE EXTENSION unaccent;