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: Functionality such as sync/async HTTP, GZIP, JWT, SaltedHash, Extra Window Aggs, PCRE, ICU, ID & Rand Generator, etc…

FUNC category has 55 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
topn topn PGDG 2.6.0 FUNC AGPLv3 type for top-n JSONB
gzip pg_gzip PGDG 1.0 FUNC MIT gzip and gunzip functions.
zstd pg_zstd PIGSTY 1.1.0 FUNC ISC Zstandard compression algorithm implementation in PostgreSQL
http pg_http PGDG 1.6 FUNC MIT HTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_net pg_net PGDG 0.9.2 FUNC Apache-2.0 Async HTTP Requests
pg_html5_email_address pg_html5_email_address PIGSTY 1.2.3 FUNC PostgreSQL PostgreSQL email validation that is consistent with the HTML5 spec
pgsql_tweaks pgsql_tweaks PGDG 0.10.3 FUNC PostgreSQL Some functions and views for daily usage
pg_extra_time pg_extra_time PGDG 1.1.3 FUNC PostgreSQL Some date time functions and operators that,
timeit pg_timeit PIGSTY 1.0 FUNC PostgreSQL High-accuracy timing of SQL expressions
count_distinct count_distinct PGDG 3.0.1 FUNC BSD 2 An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
extra_window_functions extra_window_functions PGDG 1.0 FUNC PostgreSQL Extra Window Functions for PostgreSQL
first_last_agg first_last_agg PIGSTY 0.1.4 FUNC PostgreSQL first() and last() aggregate functions
tdigest tdigest PGDG 1.4.1 FUNC Apache-2.0 Provides tdigest aggregate function.
aggs_for_vecs aggs_for_vecs PIGSTY 1.3.0 FUNC MIT Aggregate functions for array inputs
aggs_for_arrays aggs_for_arrays PIGSTY 1.3.2 FUNC MIT Various functions for computing statistics on arrays of numbers
arraymath pg_arraymath PIGSTY 1.1 FUNC MIT Array math and operators that work element by element on the contents of arrays
quantile quantile PIGSTY 1.1.7 FUNC BSD Quantile aggregation function
lower_quantile lower_quantile PIGSTY 1.0.0 FUNC BSD-2 Lower quantile aggregate function
pg_idkit pg_idkit PIGSTY 0.2.3 FUNC Apache-2.0 multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pg_uuidv7 pg_uuidv7 PGDG 1.5 FUNC MPLv2 pg_uuidv7: create UUIDv7 values in postgres
permuteseq permuteseq PIGSTY 1.2 FUNC PostgreSQL Pseudo-randomly permute sequences with a format-preserving encryption on elements
pg_hashids pg_hashids PIGSTY 1.3 FUNC MIT Short unique id generator for PostgreSQL, using hashids
sequential_uuids sequential_uuids PGDG 1.0.2 FUNC MIT generator of sequential UUIDs
pg_math pg_math PIGSTY 1.0 FUNC GPLv3 GSL statistical functions for postgresql
random pg_random PIGSTY 2.0.0-dev FUNC PostgreSQL random data generator
base36 pg_base36 PIGSTY 1.0.0 FUNC MIT Integer Base36 types
base62 pg_base62 PIGSTY 0.0.1 FUNC MIT Base62 extension for PostgreSQL
floatvec floatvec PIGSTY 1.0.1 FUNC MIT Math for vectors (arrays) of numbers
financial pg_financial PIGSTY 1.0.1 FUNC PostgreSQL Financial aggregate functions
pgjwt pgjwt PIGSTY 0.2.0 FUNC MIT JSON Web Token API for Postgresql
pg_hashlib pg_hashlib PIGSTY 1.1 FUNC PostgreSQL Stable hash functions for Postgres
shacrypt shacrypt PIGSTY 1.1 FUNC PostgreSQL Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptint cryptint PIGSTY 1.0.0 FUNC PostgreSQL Encryption functions for int and bigint values
pguecc pg_ecdsa PIGSTY 1.0 FUNC BSD-2 uECC bindings for Postgres
pgpcre pgpcre PIGSTY 1 FUNC PostgreSQL Perl Compatible Regular Expression functions
icu_ext icu_ext PIGSTY 1.8 FUNC PostgreSQL Access ICU functions
pgqr pgqr PIGSTY 1.0 FUNC BSD-3 QR Code generator from PostgreSQL
envvar envvar PIGSTY 1.0.0 FUNC PostgreSQL Fetch the value of an environment variable
pg_protobuf pg_protobuf PIGSTY 1.0 FUNC MIT Protobuf support for PostgreSQL
url_encode url_encode PIGSTY 1.2.5 FUNC PostgreSQL url_encode, url_decode functions
refint refint CONTRIB 1.0 FUNC PostgreSQL functions for implementing referential integrity (obsolete)
autoinc autoinc CONTRIB 1.0 FUNC PostgreSQL functions for autoincrementing fields
insert_username insert_username CONTRIB 1.0 FUNC PostgreSQL functions for tracking who changed a table
moddatetime moddatetime CONTRIB 1.0 FUNC PostgreSQL functions for tracking last modification time
tsm_system_time tsm_system_time CONTRIB 1.0 FUNC PostgreSQL TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn dict_xsyn CONTRIB 1.0 FUNC PostgreSQL text search dictionary template for extended synonym processing
tsm_system_rows tsm_system_rows CONTRIB 1.0 FUNC PostgreSQL TABLESAMPLE method which accepts number of rows as a limit
tcn tcn CONTRIB 1.0 FUNC PostgreSQL Triggered change notifications
uuid-ossp uuid-ossp CONTRIB 1.1 FUNC PostgreSQL generate universally unique identifiers (UUIDs)
btree_gist btree_gist CONTRIB 1.7 FUNC PostgreSQL support for indexing common datatypes in GiST
btree_gin btree_gin CONTRIB 1.3 FUNC PostgreSQL support for indexing common datatypes in GIN
intarray intarray CONTRIB 1.5 FUNC PostgreSQL functions, operators, and index support for 1-D arrays of integers
intagg intagg CONTRIB 1.1 FUNC PostgreSQL integer aggregator and enumerator (obsolete)
dict_int dict_int CONTRIB 1.0 FUNC PostgreSQL text search dictionary template for integers
unaccent unaccent CONTRIB 1.1 FUNC PostgreSQL text search dictionary that removes accents

1 - topn

type for top-n JSONB

Overview

PGDG 1st Party Extension: topn : type for top-n JSONB

Information

Metadata

  • Version: 2.6.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: topn_$v*
  • RPM Ver : 2.6.0
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-topn
  • DEB Ver : 2.6.0
  • DEB Deps: Nil

Details

2 - gzip

gzip and gunzip functions.

Overview

PGDG 3rd Party Extension: pg_gzip : gzip and gunzip functions.

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pgsql_gzip_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-gzip
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

3 - zstd

Zstandard compression algorithm implementation in PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg_zstd : Zstandard compression algorithm implementation in PostgreSQL

Information

Metadata

  • Version: 1.1.0
  • PG Vers: 15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_zstd_$v*
  • RPM Ver : 1.1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-zstd
  • DEB Ver : 1.1.0
  • DEB Deps: Nil

Details

4 - http

HTTP client for PostgreSQL, allows web page retrieval inside the database.

Overview

PGDG 1st Party Extension: pg_http : HTTP client for PostgreSQL, allows web page retrieval inside the database.

Information

Metadata

  • Version: 1.6
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pgsql_http_$v*
  • RPM Ver : 1.6
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-http
  • DEB Ver : 1.6
  • DEB Deps: Nil

Details

5 - pg_net

Async HTTP Requests

Overview

PGDG 3rd Party Extension: pg_net : Async HTTP Requests

Information

Metadata

  • Version: 0.9.2
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_net_$v*
  • RPM Ver : 0.9.2
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-net
  • DEB Ver : 0.9.2
  • DEB Deps: Nil

Details

6 - pg_html5_email_address

PostgreSQL email validation that is consistent with the HTML5 spec

Overview

PIGSTY 3rd Party Extension: pg_html5_email_address : PostgreSQL email validation that is consistent with the HTML5 spec

Information

Metadata

  • Version: 1.2.3
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_html5_email_address_$v
  • RPM Ver : 1.2.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-html5-email-address
  • DEB Ver : 1.2.3
  • DEB Deps: Nil

Details

7 - pgsql_tweaks

Some functions and views for daily usage

Overview

PGDG 3rd Party Extension: pgsql_tweaks : Some functions and views for daily usage

Information

Metadata

  • Version: 0.10.3
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pgsql_tweaks_$v*
  • RPM Ver : 0.10.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pgsql-tweaks
  • DEB Ver : 0.10.4
  • DEB Deps: Nil

Details

8 - pg_extra_time

Some date time functions and operators that,

Overview

PGDG 3rd Party Extension: pg_extra_time : Some date time functions and operators that,

Information

Metadata

  • Version: 1.1.3
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_extra_time_$v*
  • RPM Ver : 1.1.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-extra-time
  • DEB Ver : 1.1.3
  • DEB Deps: Nil

Details

9 - timeit

High-accuracy timing of SQL expressions

Overview

PIGSTY 3rd Party Extension: pg_timeit : High-accuracy timing of SQL expressions

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_timeit_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-timeit
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

10 - count_distinct

An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate

Overview

PGDG 3rd Party Extension: count_distinct : An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate

Information

Metadata

  • Version: 3.0.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: count_distinct_$v*
  • RPM Ver : 3.0.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-count-distinct
  • DEB Ver : 3.0.2
  • DEB Deps: Nil

Details

11 - extra_window_functions

Extra Window Functions for PostgreSQL

Overview

PGDG 1st Party Extension: extra_window_functions : Extra Window Functions for PostgreSQL

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: extra_window_functions_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-extra-window-functions
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

12 - first_last_agg

first() and last() aggregate functions

Overview

PIGSTY 3rd Party Extension: first_last_agg : first() and last() aggregate functions

Information

Metadata

  • Version: 0.1.4
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: first_last_agg_$v
  • RPM Ver : 0.1.4
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-first-last-agg
  • DEB Ver : 0.1.4
  • DEB Deps: Nil

Details

13 - tdigest

Provides tdigest aggregate function.

Overview

PGDG 1st Party Extension: tdigest : Provides tdigest aggregate function.

Information

Metadata

  • Version: 1.4.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: tdigest_$v*
  • RPM Ver : 1.4.1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-tdigest
  • DEB Ver : 1.4.1
  • DEB Deps: Nil

Details

14 - aggs_for_vecs

Aggregate functions for array inputs

Overview

PIGSTY 3rd Party Extension: aggs_for_vecs : Aggregate functions for array inputs

Information

Metadata

  • Version: 1.3.0
  • PG Vers: 15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: aggs_for_vecs_$v*
  • RPM Ver : 1.3.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-aggs-for-vecs
  • DEB Ver : 1.3.0
  • DEB Deps: Nil

Details

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

Information

Metadata

  • Version: 1.3.2
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: aggs_for_arrays_$v*
  • RPM Ver : 1.3.2
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-aggs-for-arrays
  • DEB Ver : 1.3.2
  • DEB Deps: Nil

Details

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

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_arraymath_$v*
  • RPM Ver : 1.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-arraymath
  • DEB Ver : 1.1
  • DEB Deps: Nil

Details

17 - quantile

Quantile aggregation function

Overview

PIGSTY 3rd Party Extension: quantile : Quantile aggregation function

Information

Metadata

  • Version: 1.1.7
  • PG Vers: 15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: quantile_$v*
  • RPM Ver : 1.1.7
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-quantile
  • DEB Ver : 1.1.7
  • DEB Deps: Nil

Details

18 - lower_quantile

Lower quantile aggregate function

Overview

PIGSTY 3rd Party Extension: lower_quantile : Lower quantile aggregate function

Information

Metadata

  • Version: 1.0.0
  • PG Vers: 15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: lower_quantile_$v*
  • RPM Ver : 1.0.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-lower-quantile
  • DEB Ver : 1.0.0
  • DEB Deps: Nil

Details

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

Information

Metadata

  • Version: 0.2.3
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_idkit_$v
  • RPM Ver : 0.2.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-idkit
  • DEB Ver : 0.2.3
  • DEB Deps: Nil

Details

20 - pg_uuidv7

pg_uuidv7: create UUIDv7 values in postgres

Overview

PGDG 3rd Party Extension: pg_uuidv7 : pg_uuidv7: create UUIDv7 values in postgres

Information

Metadata

  • Version: 1.5
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_uuidv7_$v*
  • RPM Ver : 1.5
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-uuidv7
  • DEB Ver : 1.5
  • DEB Deps: Nil

Details

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

Information

Metadata

  • Version: 1.2
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: permuteseq_$v*
  • RPM Ver : 1.2
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-permuteseq
  • DEB Ver : 1.2
  • DEB Deps: Nil

Details

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

Information

Metadata

  • Version: 1.3
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_hashids_$v*
  • RPM Ver : 1.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-hashids
  • DEB Ver : 1.3
  • DEB Deps: Nil

Details

23 - sequential_uuids

generator of sequential UUIDs

Overview

PGDG 3rd Party Extension: sequential_uuids : generator of sequential UUIDs

Information

Metadata

  • Version: 1.0.2
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: sequential_uuids_$v*
  • RPM Ver : 1.0.2
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-sequential-uuids
  • DEB Ver : 1.0.2
  • DEB Deps: Nil

Details

24 - pg_math

GSL statistical functions for postgresql

Overview

PIGSTY 3rd Party Extension: pg_math : GSL statistical functions for postgresql

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_math_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-math
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

25 - random

random data generator

Overview

PIGSTY 3rd Party Extension: pg_random : random data generator

Information

Metadata

  • Version: 2.0.0-dev
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_random_$v*
  • RPM Ver : 2.0.0-dev
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-random
  • DEB Ver : 2.0.0-dev
  • DEB Deps: Nil

Details

26 - base36

Integer Base36 types

Overview

PIGSTY 3rd Party Extension: pg_base36 : Integer Base36 types

Information

Metadata

  • Version: 1.0.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_base36_$v*
  • RPM Ver : 1.0.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-base36
  • DEB Ver : 1.0.0
  • DEB Deps: Nil

Details

27 - base62

Base62 extension for PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg_base62 : Base62 extension for PostgreSQL

Information

Metadata

  • Version: 0.0.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_base62_$v*
  • RPM Ver : 0.0.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-base62
  • DEB Ver : 0.0.1
  • DEB Deps: Nil

Details

28 - floatvec

Math for vectors (arrays) of numbers

Overview

PIGSTY 3rd Party Extension: floatvec : Math for vectors (arrays) of numbers

Information

Metadata

  • Version: 1.0.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: floatvec_$v*
  • RPM Ver : 1.0.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-floatvec
  • DEB Ver : 1.0.1
  • DEB Deps: Nil

Details

29 - financial

Financial aggregate functions

Overview

PIGSTY 3rd Party Extension: pg_financial : Financial aggregate functions

Information

Metadata

  • Version: 1.0.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_financial_$v*
  • RPM Ver : 1.0.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-financial
  • DEB Ver : 1.0.1
  • DEB Deps: Nil

Details

30 - pgjwt

JSON Web Token API for Postgresql

Overview

PIGSTY 3rd Party Extension: pgjwt : JSON Web Token API for Postgresql

Information

Metadata

  • Version: 0.2.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pgjwt_$v*
  • RPM Ver : 0.2.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pgjwt
  • DEB Ver : 0.2.0
  • DEB Deps: Nil

Details

31 - pg_hashlib

Stable hash functions for Postgres

Overview

PIGSTY 3rd Party Extension: pg_hashlib : Stable hash functions for Postgres

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_hashlib_$v
  • RPM Ver : 1.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-hashlib
  • DEB Ver : 1.1
  • DEB Deps: Nil

Details

32 - shacrypt

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

Overview

PIGSTY 3rd Party Extension: shacrypt : Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: postgres_shacrypt_$v*
  • RPM Ver : 1.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-shacrypt
  • DEB Ver : 1.1
  • DEB Deps: Nil

Details

33 - cryptint

Encryption functions for int and bigint values

Overview

PIGSTY 3rd Party Extension: cryptint : Encryption functions for int and bigint values

Information

Metadata

  • Version: 1.0.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: cryptint_$v*
  • RPM Ver : 1.0.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-cryptint
  • DEB Ver : 1.0.0
  • DEB Deps: Nil

Details

34 - pguecc

uECC bindings for Postgres

Overview

PIGSTY 3rd Party Extension: pg_ecdsa : uECC bindings for Postgres

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_ecdsa_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-ecdsa
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

35 - pgpcre

Perl Compatible Regular Expression functions

Overview

PIGSTY 3rd Party Extension: pgpcre : Perl Compatible Regular Expression functions

Information

Metadata

  • Version: 1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pgpcre_$v
  • RPM Ver : 1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgpcre
  • DEB Ver : 1
  • DEB Deps: Nil

Details

36 - icu_ext

Access ICU functions

Overview

PIGSTY 3rd Party Extension: icu_ext : Access ICU functions

Information

Metadata

  • Version: 1.8
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: icu_ext_$v*
  • RPM Ver : 1.8
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-icu-ext
  • DEB Ver : 1.8
  • DEB Deps: Nil

Details

37 - pgqr

QR Code generator from PostgreSQL

Overview

PIGSTY 3rd Party Extension: pgqr : QR Code generator from PostgreSQL

Information

Metadata

  • Version: 1.0
  • PG Vers: 15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pgqr_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pgqr
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

38 - envvar

Fetch the value of an environment variable

Overview

PIGSTY 3rd Party Extension: envvar : Fetch the value of an environment variable

Information

Metadata

  • Version: 1.0.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_envvar_$v*
  • RPM Ver : 1.0.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-envvar
  • DEB Ver : 1.0.0
  • DEB Deps: Nil

Details

39 - pg_protobuf

Protobuf support for PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg_protobuf : Protobuf support for PostgreSQL

Information

Metadata

  • Version: 1.0
  • PG Vers: 15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_protobuf_$v
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-protobuf
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

40 - url_encode

url_encode, url_decode functions

Overview

PIGSTY 3rd Party Extension: url_encode : url_encode, url_decode functions

Information

Metadata

  • Version: 1.2.5
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: url_encode_$v*
  • RPM Ver : 1.2.5
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-url-encode
  • DEB Ver : 1.2.5
  • DEB Deps: Nil

Details

41 - refint

functions for implementing referential integrity (obsolete)

Overview

CONTRIB Built-in Extension: refint : functions for implementing referential integrity (obsolete)

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

42 - autoinc

functions for autoincrementing fields

Overview

CONTRIB Built-in Extension: autoinc : functions for autoincrementing fields

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

43 - insert_username

functions for tracking who changed a table

Overview

CONTRIB Built-in Extension: insert_username : functions for tracking who changed a table

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

44 - moddatetime

functions for tracking last modification time

Overview

CONTRIB Built-in Extension: moddatetime : functions for tracking last modification time

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

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

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

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

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

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

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

48 - tcn

Triggered change notifications

Overview

CONTRIB Built-in Extension: tcn : Triggered change notifications

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

49 - uuid-ossp

generate universally unique identifiers (UUIDs)

Overview

CONTRIB Built-in Extension: uuid-ossp : generate universally unique identifiers (UUIDs)

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

50 - btree_gist

support for indexing common datatypes in GiST

Overview

CONTRIB Built-in Extension: btree_gist : support for indexing common datatypes in GiST

Information

Metadata

  • Version: 1.7
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

51 - btree_gin

support for indexing common datatypes in GIN

Overview

CONTRIB Built-in Extension: btree_gin : support for indexing common datatypes in GIN

Information

Metadata

  • Version: 1.3
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

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

Information

Metadata

  • Version: 1.5
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

53 - intagg

integer aggregator and enumerator (obsolete)

Overview

CONTRIB Built-in Extension: intagg : integer aggregator and enumerator (obsolete)

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

54 - dict_int

text search dictionary template for integers

Overview

CONTRIB Built-in Extension: dict_int : text search dictionary template for integers

Information

Metadata

  • Version: 1.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details

55 - unaccent

text search dictionary that removes accents

Overview

CONTRIB Built-in Extension: unaccent : text search dictionary that removes accents

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension


Details