UTIL

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

UTIL category contains 31 PostgreSQL extensions.

ID	Extension	Package	Version	Description
4010	`gzip`	`pg_gzip`	1.0.1	gzip and gunzip functions.
4020	`bzip`	`pg_bzip`	1.0.0	Bzip compression and decompression
4030	`zstd`	`pg_zstd`	1.1.2	Zstandard compression algorithm implementation in PostgreSQL
4070	`http`	`pg_http`	1.7.0	HTTP client for PostgreSQL, allows web page retrieval inside the database.
4080	`pg_net`	`pg_net`	0.9.2	Async HTTP Requests
4090	`pg_curl`	`pg_curl`	2.4.5	Run curl actions for data transfer in URL syntax
4150	`pgjq`	`pgjq`	0.1.0	Use jq in Postgres
4160	`pgjwt`	`pgjwt`	0.2.0	JSON Web Token API for Postgresql
4170	`pg_smtp_client`	`pg_smtp_client`	0.2.0	PostgreSQL extension to send email using SMTP
4180	`pg_html5_email_address`	`pg_html5_email_address`	1.2.3	PostgreSQL email validation that is consistent with the HTML5 spec
4190	`url_encode`	`url_encode`	1.2.5	url_encode, url_decode functions
4200	`pgsql_tweaks`	`pgsql_tweaks`	0.11.3	Some functions and views for daily usage
4220	`pg_extra_time`	`pg_extra_time`	2.0.0	Some date time functions and operators that,
4230	`pgpcre`	`pgpcre`	1	Perl Compatible Regular Expression functions
4240	`icu_ext`	`icu_ext`	1.10.0	Access ICU functions
4250	`pgqr`	`pgqr`	1.0	QR Code generator from PostgreSQL
4260	`pg_protobuf`	`pg_protobuf`	1.0	Protobuf support for PostgreSQL
4270	`envvar`	`envvar`	1.0.1	Fetch the value of an environment variable
4280	`floatfile`	`floatfile`	1.3.1	Simple file storage for arrays of floats
4290	`pg_render`	`pg_render`	0.1.2	Render HTML in SQL
4300	`pg_readme`	`pg_readme`	0.7.0	Generate a README.md document for a database extension or schema
4301	`pg_readme_test_extension`	`pg_readme`	0.7.0	Test generating a README.md document for extension or schema
4310	`ddl_historization`	`ddl_historization`	0.0.7	Historize the ddl changes inside PostgreSQL database
4320	`data_historization`	`data_historization`	1.1.0	PLPGSQL Script to historize data in partitionned table
4330	`schedoc`	`pg_schedoc`	0.0.1	Cross documentation between Django and DBT projects
4400	`hashlib`	`pg_hashlib`	1.1	Stable hash functions for Postgres
4430	`xxhash`	`pg_xxhash`	0.0.1	xxhash functions for PostgreSQL
4440	`shacrypt`	`shacrypt`	1.1	Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
4450	`cryptint`	`cryptint`	1.0.0	Encryption functions for int and bigint values
4460	`pguecc`	`pg_ecdsa`	1.0	uECC bindings for Postgres
4470	`sparql`	`pgsparql`	1.0	Query SPARQL datasource with SQL

gzip - 1.0.1

gzip and gunzip functions.

Extension	Website	Attributes
Package	`pg_gzip`
RPM	`pgsql_gzip_$v*`	DDL
DEB	`postgresql-$v-gzip`	LIB
Language	C
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

bzip - 1.0.0

Bzip compression and decompression

Extension	Website	Attributes
Package	`pg_bzip`
RPM	`pg_bzip_$v*`	DDL
DEB	`postgresql-$v-bzip`	LIB
Language	C
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

zstd - 1.1.2

Zstandard compression algorithm implementation in PostgreSQL

Extension	Website	Attributes
Package	`pg_zstd`
RPM	`pg_zstd_$v*`	DDL
DEB	`postgresql-$v-zstd`	LIB
Language	C
License	ISC

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

http - 1.7.0

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

Extension	Website	Attributes
Package	`pg_http`
RPM	`pgsql_http_$v*`	DDL
DEB	`postgresql-$v-http`	LIB
Language	C
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_net - 0.9.2

Async HTTP Requests

Extension	Website	Attributes
Package	`pg_net`	LOAD
RPM	`pg_net_$v*`	DDL
DEB	`postgresql-$v-pg-net`	LIB
Language	C
License	Apache-2.0

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_curl - 2.4.5

Run curl actions for data transfer in URL syntax

Extension	Website	Attributes
Package	`pg_curl`
RPM	`pg_curl_$v*`	DDL
DEB	`postgresql-$v-pg-curl`	LIB
Language	C
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgjq - 0.1.0

Use jq in Postgres

Extension	Website	Attributes
Package	`pgjq`
RPM	`pgjq_$v*`	DDL
DEB	`postgresql-$v-pgjq`	LIB
Language	C	TRUST
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgjwt - 0.2.0

JSON Web Token API for Postgresql

Extension	Website	Attributes
Package	`pgjwt`
RPM	`pgjwt_$v`	DDL
DEB	`postgresql-$v-pgjwt`	LIB
Language	SQL
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_smtp_client - 0.2.0

PostgreSQL extension to send email using SMTP

Extension	Website	Attributes
Package	`pg_smtp_client`
RPM	`pg_smtp_client_$v`	DDL
DEB	`postgresql-$v-pg-smtp-client`	LIB
Language	Rust	TRUST
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_html5_email_address - 1.2.3

PostgreSQL email validation that is consistent with the HTML5 spec

Extension	Website	Attributes
Package	`pg_html5_email_address`
RPM	`pg_html5_email_address_$v`	DDL
DEB	`postgresql-$v-pg-html5-email-address`
Language	SQL
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

url_encode - 1.2.5

url_encode, url_decode functions

Extension	Website	Attributes
Package	`url_encode`
RPM	`url_encode_$v*`	DDL
DEB	`postgresql-$v-url-encode`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgsql_tweaks - 0.11.3

Some functions and views for daily usage

Extension	Website	Attributes
Package	`pgsql_tweaks`
RPM	`pgsql_tweaks_$v`	DDL
DEB	`postgresql-$v-pgsql-tweaks`	LIB
Language	SQL
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_extra_time - 2.0.0

Some date time functions and operators that,

Extension	Website	Attributes
Package	`pg_extra_time`
RPM	`pg_extra_time_$v`	DDL
DEB	`postgresql-$v-pg-extra-time`	LIB
Language	SQL	TRUST
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgpcre - 1

Perl Compatible Regular Expression functions

Extension	Website	Attributes
Package	`pgpcre`
RPM	`pgpcre_$v`	DDL
DEB	`postgresql-$v-pgpcre`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

icu_ext - 1.10.0

Access ICU functions

Extension	Website	Attributes
Package	`icu_ext`
RPM	`icu_ext_$v*`	DDL
DEB	`postgresql-$v-icu-ext`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgqr - 1.0

QR Code generator from PostgreSQL

Extension	Website	Attributes
Package	`pgqr`
RPM	`pgqr_$v*`	DDL
DEB	`postgresql-$v-pgqr`	LIB
Language	C
License	BSD 3-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_protobuf - 1.0

Protobuf support for PostgreSQL

Extension	Website	Attributes
Package	`pg_protobuf`
RPM	`pg_protobuf_$v`	DDL
DEB	`postgresql-$v-pg-protobuf`	LIB
Language	C
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

envvar - 1.0.1

Fetch the value of an environment variable

Extension	Website	Attributes
Package	`envvar`
RPM	`pg_envvar_$v*`	DDL
DEB	`postgresql-$v-pg-envvar`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

floatfile - 1.3.1

Simple file storage for arrays of floats

Extension	Website	Attributes
Package	`floatfile`
RPM	`floatfile_$v*`	DDL
DEB	`postgresql-$v-floatfile`	LIB
Language	C
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_render - 0.1.2

Render HTML in SQL

Extension	Website	Attributes
Package	`pg_render`
RPM	`pg_render_$v`	DDL
DEB	`postgresql-$v-pg-render`	LIB
Language	Rust
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_readme - 0.7.0

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

Extension	Website	Attributes
Package	`pg_readme`
RPM	`pg_readme_$v`	DDL
DEB	`postgresql-$v-pg-readme`
Language	C	TRUST
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_readme_test_extension - 0.7.0

Test generating a README.md document for extension or schema

Extension	Website	Attributes
Package	`pg_readme`
RPM	`pg_readme_$v`	DDL
DEB	`postgresql-$v-pg-readme`
Language	C	TRUST
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

ddl_historization - 0.0.7

Historize the ddl changes inside PostgreSQL database

Extension	Website	Attributes
Package	`ddl_historization`
RPM	`ddl_historization_$v`	DDL
DEB	`postgresql-$v-ddl-historization`
Language	SQL
License	GPL-2.0

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

data_historization - 1.1.0

PLPGSQL Script to historize data in partitionned table

Extension	Website	Attributes
Package	`data_historization`
RPM	`data_historization_$v`	DDL
DEB	`postgresql-$v-data-historization`
Language	SQL	TRUST
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

schedoc - 0.0.1

Cross documentation between Django and DBT projects

Extension	Website	Attributes
Package	`pg_schedoc`
RPM	`pg_schedoc_$v`	DDL
DEB	`postgresql-$v-pg-schedoc`
Language	SQL
License	GPL-3.0

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

hashlib - 1.1

Stable hash functions for Postgres

Extension	Website	Attributes
Package	`pg_hashlib`
RPM	`pg_hashlib_$v`	DDL
DEB	`postgresql-$v-pg-hashlib`	LIB
Language	C	TRUST
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

xxhash - 0.0.1

xxhash functions for PostgreSQL

Extension	Website	Attributes
Package	`pg_xxhash`
RPM	`pg_xxhash_$v*`	DDL
DEB	`postgresql-$v-pg-xxhash`	LIB
Language	C	TRUST
License	BSD 2-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

shacrypt - 1.1

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

Extension	Website	Attributes
Package	`shacrypt`
RPM	`postgres_shacrypt_$v*`	DDL
DEB	`postgresql-$v-shacrypt`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

cryptint - 1.0.0

Encryption functions for int and bigint values

Extension	Website	Attributes
Package	`cryptint`
RPM	`cryptint_$v*`	DDL
DEB	`postgresql-$v-cryptint`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pguecc - 1.0

uECC bindings for Postgres

Extension	Website	Attributes
Package	`pg_ecdsa`
RPM	`pg_ecdsa_$v*`	DDL
DEB	`postgresql-$v-pg-ecdsa`	LIB
Language	C
License	BSD 2-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

sparql - 1.0

Query SPARQL datasource with SQL

Extension	Website	Attributes
Package	`pgsparql`
RPM	`pgsparql_$v`	DDL
DEB	`postgresql-$v-pgsparql`
Language	SQL
License	Apache-2.0

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14