Category: UTIL

gzip and gunzip functions.

Bzip compression and decompression

Zstandard compression algorithm implementation in PostgreSQL

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

Async HTTP Requests

Run curl actions for data transfer in URL syntax

Retry SQL statements on transient errors with exponential backoff

Recursive SQL template engine with JSONB-driven execution

Protobuf support for PostgreSQL

Native Protobuf parsing, mutation, indexing, and JSON conversion support

Lightweight distributed lock service inside PostgreSQL

Use jq in Postgres

JSONB diff, JSON Patch, and JSON Merge Patch functions

JSON Web Token API for Postgresql

PostgreSQL extension to send email using SMTP

PostgreSQL email validation that is consistent with the HTML5 spec

url_encode, url_decode functions

Some functions and views for daily usage

Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations

Some date time functions and operators that,

Perl Compatible Regular Expression functions

ClickHouse-compatible regex functions using RE2

Access ICU functions

QR Code generator from PostgreSQL

Fetch the value of an environment variable

Detect MIME types and file formats from PostgreSQL bytea values

Simple file storage for arrays of floats

Access external server-side files through PostgreSQL functions

Render HTML in SQL

Generate a Markdown README from PostgreSQL COMMENT objects

Fixture extension used to test pg_readme document generation

Historize the ddl changes inside PostgreSQL database

PLPGSQL Script to historize data in partitionned table

Cross documentation between Django and DBT projects

Query-based data integrity management and soft alerting for PostgreSQL

Report a query's parameters and result columns without executing it

Return column names of a record or composite value

Stable hash functions for Postgres

xxhash functions for PostgreSQL

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

Encryption functions for int and bigint values

uECC bindings for Postgres

Query SPARQL datasource with SQL