Category: FUNC

FUNC: Functionality such as sync/async HTTP, GZIP, JWT, SaltedHash, Extra Window Aggs, PCRE, ICU, ID & Rand Generator, etc…
Module:
Categories:
Tags:

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
topn

type for top-n JSONB

gzip

gzip and gunzip functions.

zstd

Zstandard compression algorithm implementation in PostgreSQL

http

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

pg_net

Async HTTP Requests

pg_html5_email_address

PostgreSQL email validation that is consistent with the HTML5 spec

pgsql_tweaks

Some functions and views for daily usage

pg_extra_time

Some date time functions and operators that,

timeit

High-accuracy timing of SQL expressions

count_distinct

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

extra_window_functions

Extra Window Functions for PostgreSQL

first_last_agg

first() and last() aggregate functions

tdigest

Provides tdigest aggregate function.

aggs_for_vecs

Aggregate functions for array inputs

aggs_for_arrays

Various functions for computing statistics on arrays of numbers

arraymath

Array math and operators that work element by element on the contents of arrays

quantile

Quantile aggregation function

lower_quantile

Lower quantile aggregate function

pg_idkit

multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)

pg_uuidv7

pg_uuidv7: create UUIDv7 values in postgres

permuteseq

Pseudo-randomly permute sequences with a format-preserving encryption on elements

pg_hashids

Short unique id generator for PostgreSQL, using hashids

sequential_uuids

generator of sequential UUIDs

pg_math

GSL statistical functions for postgresql

random

random data generator

base36

Integer Base36 types

base62

Base62 extension for PostgreSQL

floatvec

Math for vectors (arrays) of numbers

financial

Financial aggregate functions

pgjwt

JSON Web Token API for Postgresql

pg_hashlib

Stable hash functions for Postgres

shacrypt

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

cryptint

Encryption functions for int and bigint values

pguecc

uECC bindings for Postgres

pgpcre

Perl Compatible Regular Expression functions

icu_ext

Access ICU functions

pgqr

QR Code generator from PostgreSQL

envvar

Fetch the value of an environment variable

pg_protobuf

Protobuf support for PostgreSQL

url_encode

url_encode, url_decode functions

refint

functions for implementing referential integrity (obsolete)

autoinc

functions for autoincrementing fields

insert_username

functions for tracking who changed a table

moddatetime

functions for tracking last modification time

tsm_system_time

TABLESAMPLE method which accepts time in milliseconds as a limit

dict_xsyn

text search dictionary template for extended synonym processing

tsm_system_rows

TABLESAMPLE method which accepts number of rows as a limit

tcn

Triggered change notifications

uuid-ossp

generate universally unique identifiers (UUIDs)

btree_gist

support for indexing common datatypes in GiST

btree_gin

support for indexing common datatypes in GIN

intarray

functions, operators, and index support for 1-D arrays of integers

intagg

integer aggregator and enumerator (obsolete)

dict_int

text search dictionary template for integers

unaccent

text search dictionary that removes accents


Last modified 2024-08-26: update pg_net version (bf07d00)