UTIL - Utility

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

Extension List

There are 32 extensions in 31 packages.

ExtensionPackageVersionLicenseLanguageDescription
gzippg_gzip1.0.0MITCgzip and gunzip functions.
bzippg_bzip1.0.0MITCBzip compression and decompression
zstdpg_zstd1.1.2ISCCZstandard compression algorithm implementation in PostgreSQL
httppg_http1.7.0MITCHTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_netpg_net0.20.2Apache-2.0CAsync HTTP Requests
pg_curlpg_curl2.4.5MITCRun curl actions for data transfer in URL syntax
pg_retrypg_retry1.0.0PostgreSQLCRetry SQL statements on transient errors with exponential backoff
pgjqpgjq0.1.0MITCUse jq in Postgres
pgjwtpgjwt0.2.0MITSQLJSON Web Token API for Postgresql
pg_smtp_clientpg_smtp_client0.2.1MITRustPostgreSQL extension to send email using SMTP
pg_html5_email_addresspg_html5_email_address1.2.3PostgreSQLSQLPostgreSQL email validation that is consistent with the HTML5 spec
url_encodeurl_encode1.2.5PostgreSQLCurl_encode, url_decode functions
pgsql_tweakspgsql_tweaks1.0.2PostgreSQLSQLSome functions and views for daily usage
pg_extra_timepg_extra_time2.0.0PostgreSQLSQLSome date time functions and operators that,
pgpcrepgpcre0.20190509PostgreSQLCPerl Compatible Regular Expression functions
icu_exticu_ext1.10.0PostgreSQLCAccess ICU functions
pgqrpgqr1.0BSD 3-ClauseCQR Code generator from PostgreSQL
pg_protobufpg_protobuf1.0MITCProtobuf support for PostgreSQL
envvarpg_envvar1.0.1PostgreSQLCFetch the value of an environment variable
floatfilefloatfile1.3.1MITCSimple file storage for arrays of floats
pg_renderpg_render0.1.3MITRustRender HTML in SQL
pg_readmepg_readme0.7.0PostgreSQLCGenerate a README.md document for a database extension or schema
pg_readme_test_extensionpg_readme0.7.0PostgreSQLCTest generating a README.md document for extension or schema
ddl_historizationddl_historization0.0.7GPL-2.0SQLHistorize the ddl changes inside PostgreSQL database
data_historizationdata_historization1.1.0PostgreSQLSQLPLPGSQL Script to historize data in partitionned table
schedocpg_schedoc0.0.1GPL-3.0SQLCross documentation between Django and DBT projects
hashlibpg_hashlib1.1PostgreSQLCStable hash functions for Postgres
xxhashpg_xxhash0.0.1BSD 2-ClauseCxxhash functions for PostgreSQL
shacryptshacrypt1.1PostgreSQLCImplements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptintcryptint1.0.0PostgreSQLCEncryption functions for int and bigint values
pgueccpg_ecdsa1.0BSD 2-ClauseCuECC bindings for Postgres
sparqlpgsparql1.0Apache-2.0SQLQuery SPARQL datasource with SQL

gzip

pg_gzip - 1.0.0 : gzip and gunzip functions.

ItemValueOSx86_64aarch64
Extensiongzipel818171615141817161514
Packagepg_gzipel918171615141817161514
RPMpg_gzip_$vel1018171615141817161514
DEBpostgresql-$v-gzipd1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseMITu2418171615141817161514

bzip

pg_bzip - 1.0.0 : Bzip compression and decompression

ItemValueOSx86_64aarch64
Extensionbzipel818171615141817161514
Packagepg_bzipel918171615141817161514
RPMpg_bzip_$vel1018171615141817161514
DEBpostgresql-$v-bzipd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

zstd

pg_zstd - 1.1.2 : Zstandard compression algorithm implementation in PostgreSQL

ItemValueOSx86_64aarch64
Extensionzstdel818171615141817161514
Packagepg_zstdel918171615141817161514
RPMpg_zstd_$vel1018171615141817161514
DEBpostgresql-$v-zstdd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseISCu2418171615141817161514

http

pg_http - 1.7.0 : HTTP client for PostgreSQL, allows web page retrieval inside the database.

ItemValueOSx86_64aarch64
Extensionhttpel818171615141817161514
Packagepg_httpel918171615141817161514
RPMpg_http_$vel1018171615141817161514
DEBpostgresql-$v-httpd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicenseMITu2418171615141817161514

pg_net

pg_net - 0.20.2 : Async HTTP Requests

ItemValueOSx86_64aarch64
Extensionpg_netel818171615141817161514
Packagepg_netel918171615141817161514
RPMpg_net_$vel1018171615141817161514
DEBpostgresql-$v-pg-netd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

pg_curl

pg_curl - 2.4.5 : Run curl actions for data transfer in URL syntax

ItemValueOSx86_64aarch64
Extensionpg_curlel818171615141817161514
Packagepg_curlel918171615141817161514
RPMpg_curl_$vel1018171615141817161514
DEBpostgresql-$v-pg-curld1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_retry

pg_retry - 1.0.0 : Retry SQL statements on transient errors with exponential backoff

ItemValueOSx86_64aarch64
Extensionpg_retryel818171615141817161514
Packagepg_retryel918171615141817161514
RPMpg_retry_$vel1018171615141817161514
DEBpostgresql-$v-retryd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pgjq

pgjq - 0.1.0 : Use jq in Postgres

ItemValueOSx86_64aarch64
Extensionpgjqel818171615141817161514
Packagepgjqel918171615141817161514
RPMpgjq_$vel1018171615141817161514
DEBpostgresql-$v-pgjqd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pgjwt

pgjwt - 0.2.0 : JSON Web Token API for Postgresql

ItemValueOSx86_64aarch64
Extensionpgjwtel818171615141817161514
Packagepgjwtel918171615141817161514
RPMpgjwt_$vel1018171615141817161514
DEBpostgresql-$v-pgjwtd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_smtp_client

pg_smtp_client - 0.2.1 : PostgreSQL extension to send email using SMTP

ItemValueOSx86_64aarch64
Extensionpg_smtp_clientel818171615141817161514
Packagepg_smtp_clientel918171615141817161514
RPMpg_smtp_client_$vel1018171615141817161514
DEBpostgresql-$v-pg-smtp-clientd1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_html5_email_address

pg_html5_email_address - 1.2.3 : PostgreSQL email validation that is consistent with the HTML5 spec

ItemValueOSx86_64aarch64
Extensionpg_html5_email_addressel818171615141817161514
Packagepg_html5_email_addressel918171615141817161514
RPMpg_html5_email_address_$vel1018171615141817161514
DEBpostgresql-$v-pg-html5-email-addressd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

url_encode

url_encode - 1.2.5 : url_encode, url_decode functions

ItemValueOSx86_64aarch64
Extensionurl_encodeel818171615141817161514
Packageurl_encodeel918171615141817161514
RPMurl_encode_$vel1018171615141817161514
DEBpostgresql-$v-url-encoded1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pgsql_tweaks

pgsql_tweaks - 1.0.2 : Some functions and views for daily usage

ItemValueOSx86_64aarch64
Extensionpgsql_tweaksel818171615141817161514
Packagepgsql_tweaksel918171615141817161514
RPMpgsql_tweaks_$vel1018171615141817161514
DEBpostgresql-$v-pgsql-tweaksd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_extra_time

pg_extra_time - 2.0.0 : Some date time functions and operators that,

ItemValueOSx86_64aarch64
Extensionpg_extra_timeel818171615141817161514
Packagepg_extra_timeel918171615141817161514
RPMpg_extra_time_$vel1018171615141817161514
DEBpostgresql-$v-pg-extra-timed1218171615141817161514
LanguageSQLd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pgpcre

pgpcre - 0.20190509 : Perl Compatible Regular Expression functions

ItemValueOSx86_64aarch64
Extensionpgpcreel818171615141817161514
Packagepgpcreel918171615141817161514
RPMpgpcre_$vel1018171615141817161514
DEBpostgresql-$v-pgpcred1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

icu_ext

icu_ext - 1.10.0 : Access ICU functions

ItemValueOSx86_64aarch64
Extensionicu_extel818171615141817161514
Packageicu_extel918171615141817161514
RPMicu_ext_$vel1018171615141817161514
DEBpostgresql-$v-icu-extd1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pgqr

pgqr - 1.0 : QR Code generator from PostgreSQL

ItemValueOSx86_64aarch64
Extensionpgqrel818171615141817161514
Packagepgqrel918171615141817161514
RPMpgqr_$vel1018171615141817161514
DEBpostgresql-$v-pgqrd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseBSD 3-Clauseu2418171615141817161514

pg_protobuf

pg_protobuf - 1.0 : Protobuf support for PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_protobufel818171615141817161514
Packagepg_protobufel918171615141817161514
RPMpg_protobuf_$vel1018171615141817161514
DEBpostgresql-$v-pg-protobufd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

envvar

pg_envvar - 1.0.1 : Fetch the value of an environment variable

ItemValueOSx86_64aarch64
Extensionenvvarel818171615141817161514
Packagepg_envvarel918171615141817161514
RPMpg_envvar_$vel1018171615141817161514
DEBpostgresql-$v-pg-envvard1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

floatfile

floatfile - 1.3.1 : Simple file storage for arrays of floats

ItemValueOSx86_64aarch64
Extensionfloatfileel818171615141817161514
Packagefloatfileel918171615141817161514
RPMfloatfile_$vel1018171615141817161514
DEBpostgresql-$v-floatfiled1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_render

pg_render - 0.1.3 : Render HTML in SQL

ItemValueOSx86_64aarch64
Extensionpg_renderel818171615141817161514
Packagepg_renderel918171615141817161514
RPMpg_render_$vel1018171615141817161514
DEBpostgresql-$v-pg-renderd1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_readme

pg_readme - 0.7.0 : Generate a README.md document for a database extension or schema

ItemValueOSx86_64aarch64
Extensionpg_readmeel818171615141817161514
Packagepg_readmeel918171615141817161514
RPMpg_readme_$vel1018171615141817161514
DEBpostgresql-$v-pg-readmed1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_readme_test_extension

pg_readme - 0.7.0 : Test generating a README.md document for extension or schema

ItemValueOSx86_64aarch64
Extensionpg_readme_test_extensionel818171615141817161514
Packagepg_readmeel918171615141817161514
RPMpg_readme_$vel1018171615141817161514
DEBpostgresql-$v-pg-readmed1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

ddl_historization

ddl_historization - 0.0.7 : Historize the ddl changes inside PostgreSQL database

ItemValueOSx86_64aarch64
Extensionddl_historizationel818171615141817161514
Packageddl_historizationel918171615141817161514
RPMddl_historization_$vel1018171615141817161514
DEBpostgresql-$v-ddl-historizationd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseGPL-2.0u2418171615141817161514

data_historization

data_historization - 1.1.0 : PLPGSQL Script to historize data in partitionned table

ItemValueOSx86_64aarch64
Extensiondata_historizationel818171615141817161514
Packagedata_historizationel918171615141817161514
RPMdata_historization_$vel1018171615141817161514
DEBpostgresql-$v-data-historizationd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

schedoc

pg_schedoc - 0.0.1 : Cross documentation between Django and DBT projects

ItemValueOSx86_64aarch64
Extensionschedocel818171615141817161514
Packagepg_schedocel918171615141817161514
RPMpg_schedoc_$vel1018171615141817161514
DEBpostgresql-$v-pg-schedocd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseGPL-3.0u2418171615141817161514

hashlib

pg_hashlib - 1.1 : Stable hash functions for Postgres

ItemValueOSx86_64aarch64
Extensionhashlibel818171615141817161514
Packagepg_hashlibel918171615141817161514
RPMpg_hashlib_$vel1018171615141817161514
DEBpostgresql-$v-pg-hashlibd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

xxhash

pg_xxhash - 0.0.1 : xxhash functions for PostgreSQL

ItemValueOSx86_64aarch64
Extensionxxhashel818171615141817161514
Packagepg_xxhashel918171615141817161514
RPMpg_xxhash_$vel1018171615141817161514
DEBpostgresql-$v-pg-xxhashd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseBSD 2-Clauseu2418171615141817161514

shacrypt

shacrypt - 1.1 : Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

ItemValueOSx86_64aarch64
Extensionshacryptel818171615141817161514
Packageshacryptel918171615141817161514
RPMshacrypt_$vel1018171615141817161514
DEBpostgresql-$v-shacryptd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

cryptint

cryptint - 1.0.0 : Encryption functions for int and bigint values

ItemValueOSx86_64aarch64
Extensioncryptintel818171615141817161514
Packagecryptintel918171615141817161514
RPMcryptint_$vel1018171615141817161514
DEBpostgresql-$v-cryptintd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pguecc

pg_ecdsa - 1.0 : uECC bindings for Postgres

ItemValueOSx86_64aarch64
Extensionpgueccel818171615141817161514
Packagepg_ecdsael918171615141817161514
RPMpg_ecdsa_$vel1018171615141817161514
DEBpostgresql-$v-pg-ecdsad1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseBSD 2-Clauseu2418171615141817161514

sparql

pgsparql - 1.0 : Query SPARQL datasource with SQL

ItemValueOSx86_64aarch64
Extensionsparqlel818171615141817161514
Packagepgsparqlel918171615141817161514
RPMpgsparql_$vel1018171615141817161514
DEBpostgresql-$v-pgsparqld1218171615141817161514
LanguageSQLd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

Last Modified 2026-03-12: add pg extension catalog (95749bf)