Category: FUNC
FUNC: Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…
Tags: FUNC
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:
topn
type for top-n JSONB
Module:
Categories:
quantile
Quantile aggregation function
Module:
Categories:
lower_quantile
Lower quantile aggregate function
Module:
Categories:
count_distinct
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
Module:
Categories:
omnisketch
data structure for on-line agg of data into approximate sketch
Module:
Categories:
ddsketch
Provides ddsketch aggregate function
Module:
Categories:
vasco
discover hidden correlations in your data with MIC
Module:
Categories:
xicor
XI Correlation Coefficient in Postgres
Module:
Categories:
tdigest
Provides tdigest aggregate function.
Module:
Categories:
first_last_agg
first() and last() aggregate functions
Module:
Categories:
extra_window_functions
Extra Window Functions for PostgreSQL
Module:
Categories:
floatvec
Math for vectors (arrays) of numbers
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:
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:
financial
Financial aggregate 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:
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