Category: UTIL

UTIL: Utilities such as send http request, perform gzip/zstd compress, send mails, Regex, ICU, encoding, docs, Encryption,…

UTIL category has 28 available extensions:

Name (Detail) Package (Repo) Repo Version Category License LOAD DDL TRUST RELOC Description
zstd pg_zstd PIGSTY 1.1.0 UTIL ISC Zstandard compression algorithm implementation in PostgreSQL
gzip pg_gzip MIXED 1.0 UTIL MIT gzip and gunzip functions.
http pg_http PGDG 1.6 UTIL MIT HTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_net pg_net PIGSTY 0.8.0 UTIL Apache-2.0 Async HTTP Requests
pg_curl pg_curl PIGSTY 2.4 UTIL MIT Run curl actions for data transfer in URL syntax
pgjq pgjq PIGSTY 0.1.0 UTIL MIT Use jq in Postgres
pgjwt pgjwt PIGSTY 0.2.0 UTIL MIT JSON Web Token API for Postgresql
pg_smtp_client pg_smtp_client PIGSTY 0.2.0 UTIL MIT PostgreSQL extension to send email using SMTP
pg_html5_email_address pg_html5_email_address PIGSTY 1.2.3 UTIL PostgreSQL PostgreSQL email validation that is consistent with the HTML5 spec
url_encode url_encode PIGSTY 1.2 UTIL PostgreSQL url_encode, url_decode functions
pgsql_tweaks pgsql_tweaks MIXED 0.10.7 UTIL PostgreSQL Some functions and views for daily usage
pg_extra_time pg_extra_time MIXED 2.0.0 UTIL PostgreSQL Some date time functions and operators that,
pgpcre pgpcre MIXED 1 UTIL PostgreSQL Perl Compatible Regular Expression functions
icu_ext icu_ext MIXED 1.9 UTIL PostgreSQL Access ICU functions
pgqr pgqr PIGSTY 1.0 UTIL BSD 3 QR Code generator from PostgreSQL
pg_protobuf pg_protobuf PIGSTY 1.0 UTIL MIT Protobuf support for PostgreSQL
envvar envvar PIGSTY 1.0.0 UTIL PostgreSQL Fetch the value of an environment variable
floatfile floatfile PIGSTY 1.3.1 UTIL MIT Simple file storage for arrays of floats
pg_readme pg_readme MIXED 0.7.0 UTIL PostgreSQL Generate a README.md document for a database extension or schema
ddl_historization ddl_historization PIGSTY 0.0.7 UTIL GPLv2 Historize the ddl changes inside PostgreSQL database
data_historization data_historization PIGSTY 1.1.0 UTIL PostgreSQL PLPGSQL Script to historize data in partitionned table
schedoc pg_schedoc PIGSTY 0.0.2 UTIL GPLv3 Cross documentation between Django and DBT projects
hashlib pg_hashlib PIGSTY 1.1 UTIL PostgreSQL Stable hash functions for Postgres
xxhash pg_xxhash PIGSTY 0.0.1 UTIL BSD 2 xxhash functions for PostgreSQL
shacrypt shacrypt PIGSTY 1.1 UTIL PostgreSQL Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptint cryptint PIGSTY 1.0.0 UTIL PostgreSQL Encryption functions for int and bigint values
pguecc pg_ecdsa PIGSTY 1.0 UTIL BSD 2 uECC bindings for Postgres
sparql pgsparql PIGSTY 1.0 UTIL Apache-2.0 Query SPARQL datasource with SQL

zstd

Zstandard compression algorithm implementation in PostgreSQL

gzip

gzip and gunzip functions.

http

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

pg_net

Async HTTP Requests

pg_curl

Run curl actions for data transfer in URL syntax

pgjq

Use jq in Postgres

pgjwt

JSON Web Token API for Postgresql

pg_smtp_client

PostgreSQL extension to send email using SMTP

pg_html5_email_address

PostgreSQL email validation that is consistent with the HTML5 spec

url_encode

url_encode, url_decode functions

pgsql_tweaks

Some functions and views for daily usage

pg_extra_time

Some date time functions and operators that,

pgpcre

Perl Compatible Regular Expression functions

icu_ext

Access ICU functions

pgqr

QR Code generator from PostgreSQL

pg_protobuf

Protobuf support for PostgreSQL

envvar

Fetch the value of an environment variable

floatfile

Simple file storage for arrays of floats

pg_readme

Generate a README.md document for a database extension or schema

ddl_historization

Historize the ddl changes inside PostgreSQL database

data_historization

PLPGSQL Script to historize data in partitionned table

schedoc

Cross documentation between Django and DBT projects

hashlib

Stable hash functions for Postgres

xxhash

xxhash functions for PostgreSQL

shacrypt

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

cryptint

Encryption functions for int and bigint values

pguecc

uECC bindings for Postgres

sparql

Query SPARQL datasource with SQL


Last modified 2025-02-17: add extension part (cfa504b)