FUNC - Math & Function

Extension List

There are 47 extensions in 47 packages.

pg_idkit

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

pgx_ulid

pgx_ulid - 0.2.2 : ulid type and methods

pg_uuidv7

pg_uuidv7 - 1.7.0 : Create UUIDv7 values in postgres

permuteseq

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

pg_hashids

pg_hashids - 1.3 : Short unique id generator for PostgreSQL, using hashids

sequential_uuids

sequential_uuids - 1.0.3 : generator of sequential UUIDs

typeid

pg_typeid - 0.3.0 : Allows to use TypeIDs in Postgres natively

snowflake

snowflake - 2.4 : Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL

topn

topn - 2.7.0 : type for top-n JSONB

quantile

quantile - 1.1.8 : Quantile aggregation function

lower_quantile

lower_quantile - 1.0.3 : Lower quantile aggregate function

count_distinct

count_distinct - 3.0.2 : An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate

omnisketch

omnisketch - 1.0.2 : data structure for on-line agg of data into approximate sketch

ddsketch

ddsketch - 1.0.1 : Provides ddsketch aggregate function

vasco

vasco - 0.1.0 : discover hidden correlations in your data with MIC

xicor

pgxicor - 0.1.0 : XI Correlation Coefficient in Postgres

weighted_statistics

pg_weighted_statistics - 1.0.0 : High-performance weighted statistics functions for sparse data

tdigest

tdigest - 1.4.3 : Provides tdigest aggregate function.

first_last_agg

first_last_agg - 0.1.4 : first() and last() aggregate functions

extra_window_functions

extra_window_functions - 1.0 : Extra Window Functions for PostgreSQL

floatvec

floatvec - 1.1.1 : Math for vectors (arrays) of numbers

aggs_for_vecs

aggs_for_vecs - 1.4.1 : Aggregate functions for array inputs

aggs_for_arrays

aggs_for_arrays - 1.3.3 : Various functions for computing statistics on arrays of numbers

pg_csv

pg_csv - 1.0.1 : Flexible CSV processing for Postgres

arraymath

pg_arraymath - 1.1 : Array math and operators that work element by element on the contents of arrays

pg_math

pg_math - 1.1.0 : GSL statistical functions for postgresql

random

pg_random - 2.0.0 : random data generator

base36

pg_base36 - 1.0.0 : Integer Base36 types

base62

pg_base62 - 0.0.1 : Base62 extension for PostgreSQL

pg_base58

pg_base58 - 0.0.1 : Base58 Encoder/Decoder Extension for PostgreSQL

financial

pg_financial - 1.0.1 : Financial aggregate functions

convert

pg_convert - 0.1.0 : conversion functions for spatial, routing and other specialized uses

refint

refint - 1.0 : functions for implementing referential integrity (obsolete)

autoinc

autoinc - 1.0 : functions for autoincrementing fields

insert_username

insert_username - 1.0 : functions for tracking who changed a table

moddatetime

moddatetime - 1.0 : functions for tracking last modification time

tsm_system_time

tsm_system_time - 1.0 : TABLESAMPLE method which accepts time in milliseconds as a limit

dict_xsyn

dict_xsyn - 1.0 : text search dictionary template for extended synonym processing

tsm_system_rows

tsm_system_rows - 1.0 : TABLESAMPLE method which accepts number of rows as a limit

tcn

tcn - 1.0 : Triggered change notifications

uuid-ossp

uuid-ossp - 1.1 : generate universally unique identifiers (UUIDs)

btree_gist

btree_gist - 1.7 : support for indexing common datatypes in GiST

btree_gin

btree_gin - 1.3 : support for indexing common datatypes in GIN

intarray

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