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 57 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
pg_summarize pg_summarize PIGSTY 0.0.0 FUNC PostgreSQL Text Summarization using LLMs. Built using pgrx
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 PIGSTY 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.6 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.4 FUNC Apache-2.0 multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pg_uuidv7 pg_uuidv7 PGDG 1.6 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
pg_base58 pg_base58 PIGSTY 0.0.1 FUNC MIT Base58 Encoder/Decoder 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.9 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 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
pg_summarize

Text Summarization using LLMs. Built using pgrx

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

pg_base58

Base58 Encoder/Decoder 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-10-24: add pg17 support ext info (3134bfbd)