Category: FUNC
FUNC: Functionality such as sync/async HTTP, GZIP, JWT, SaltedHash, Extra Window Aggs, PCRE, ICU, ID & Rand Generator, etc…
Tags: FUNC
pg_summarize
Text Summarization using LLMs. Built using pgrx
Module:
Categories:
topn
type for top-n JSONB
Module:
Categories:
gzip
gzip and gunzip functions.
Module:
Categories:
zstd
Zstandard compression algorithm implementation in PostgreSQL
Module:
Categories:
http
HTTP client for PostgreSQL, allows web page retrieval inside the database.
Module:
Categories:
pg_net
Async HTTP Requests
Module:
Categories:
pg_html5_email_address
PostgreSQL email validation that is consistent with the HTML5 spec
Module:
Categories:
pgsql_tweaks
Some functions and views for daily usage
Module:
Categories:
pg_extra_time
Some date time functions and operators that,
Module:
Categories:
timeit
High-accuracy timing of SQL expressions
Module:
Categories:
count_distinct
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
Module:
Categories:
extra_window_functions
Extra Window Functions for PostgreSQL
Module:
Categories:
first_last_agg
first() and last() aggregate functions
Module:
Categories:
tdigest
Provides tdigest aggregate function.
Module:
Categories:
aggs_for_vecs
Aggregate functions for array inputs
Module:
Categories:
aggs_for_arrays
Various functions for computing statistics on arrays of numbers
Module:
Categories:
arraymath
Array math and operators that work element by element on the contents of arrays
Module:
Categories:
quantile
Quantile aggregation function
Module:
Categories:
lower_quantile
Lower quantile aggregate function
Module:
Categories:
pg_idkit
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
Module:
Categories:
pg_uuidv7
pg_uuidv7: create UUIDv7 values in postgres
Module:
Categories:
permuteseq
Pseudo-randomly permute sequences with a format-preserving encryption on elements
Module:
Categories:
pg_hashids
Short unique id generator for PostgreSQL, using hashids
Module:
Categories:
sequential_uuids
generator of sequential UUIDs
Module:
Categories:
pg_math
GSL statistical functions for postgresql
Module:
Categories:
random
random data generator
Module:
Categories:
base36
Integer Base36 types
Module:
Categories:
base62
Base62 extension for PostgreSQL
Module:
Categories:
pg_base58
Base58 Encoder/Decoder Extension for PostgreSQL
Module:
Categories:
floatvec
Math for vectors (arrays) of numbers
Module:
Categories:
financial
Financial aggregate functions
Module:
Categories:
pgjwt
JSON Web Token API for Postgresql
Module:
Categories:
pg_hashlib
Stable hash functions for Postgres
Module:
Categories:
shacrypt
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
Module:
Categories:
cryptint
Encryption functions for int and bigint values
Module:
Categories:
pguecc
uECC bindings for Postgres
Module:
Categories:
pgpcre
Perl Compatible Regular Expression functions
Module:
Categories:
icu_ext
Access ICU functions
Module:
Categories:
pgqr
QR Code generator from PostgreSQL
Module:
Categories:
envvar
Fetch the value of an environment variable
Module:
Categories:
pg_protobuf
Protobuf support for PostgreSQL
Module:
Categories:
url_encode
url_encode, url_decode functions
Module:
Categories:
refint
functions for implementing referential integrity (obsolete)
Module:
Categories:
autoinc
functions for autoincrementing fields
Module:
Categories:
insert_username
functions for tracking who changed a table
Module:
Categories:
moddatetime
functions for tracking last modification time
Module:
Categories:
tsm_system_time
TABLESAMPLE method which accepts time in milliseconds as a limit
Module:
Categories:
dict_xsyn
text search dictionary template for extended synonym processing
Module:
Categories:
tsm_system_rows
TABLESAMPLE method which accepts number of rows as a limit
Module:
Categories:
tcn
Triggered change notifications
Module:
Categories:
uuid-ossp
generate universally unique identifiers (UUIDs)
Module:
Categories:
btree_gist
support for indexing common datatypes in GiST
Module:
Categories:
btree_gin
support for indexing common datatypes in GIN
Module:
Categories:
intarray
functions, operators, and index support for 1-D arrays of integers
Module:
Categories:
intagg
integer aggregator and enumerator (obsolete)
Module:
Categories:
dict_int
text search dictionary template for integers
Module:
Categories:
unaccent
text search dictionary that removes accents