PIGSTY

UTIL

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

UTIL category contains 31 PostgreSQL extensions.

IDExtensionPackageVersionDescription
4010gzippg_gzip1.0.1gzip and gunzip functions.
4020bzippg_bzip1.0.0Bzip compression and decompression
4030zstdpg_zstd1.1.2Zstandard compression algorithm implementation in PostgreSQL
4070httppg_http1.6.3HTTP client for PostgreSQL, allows web page retrieval inside the database.
4080pg_netpg_net0.9.2Async HTTP Requests
4090pg_curlpg_curl2.4Run curl actions for data transfer in URL syntax
4150pgjqpgjq0.1.0Use jq in Postgres
4160pgjwtpgjwt0.2.0JSON Web Token API for Postgresql
4170pg_smtp_clientpg_smtp_client0.2.0PostgreSQL extension to send email using SMTP
4180pg_html5_email_addresspg_html5_email_address1.2.3PostgreSQL email validation that is consistent with the HTML5 spec
4190url_encodeurl_encode1.2.5url_encode, url_decode functions
4200pgsql_tweakspgsql_tweaks0.11.1Some functions and views for daily usage
4220pg_extra_timepg_extra_time2.0.0Some date time functions and operators that,
4230pgpcrepgpcre1Perl Compatible Regular Expression functions
4240icu_exticu_ext1.9.0Access ICU functions
4250pgqrpgqr1.0QR Code generator from PostgreSQL
4260pg_protobufpg_protobuf1.0Protobuf support for PostgreSQL
4270envvarenvvar1.0.1Fetch the value of an environment variable
4280floatfilefloatfile1.3.1Simple file storage for arrays of floats
4290pg_renderpg_render0.1.2Render HTML in SQL
4300pg_readmepg_readme0.7.0Generate a README.md document for a database extension or schema
4301pg_readme_test_extensionpg_readme0.7.0Test generating a README.md document for extension or schema
4310ddl_historizationddl_historization0.0.7Historize the ddl changes inside PostgreSQL database
4320data_historizationdata_historization1.1.0PLPGSQL Script to historize data in partitionned table
4330schedocpg_schedoc0.0.1Cross documentation between Django and DBT projects
4400hashlibpg_hashlib1.1Stable hash functions for Postgres
4430xxhashpg_xxhash0.0.1xxhash functions for PostgreSQL
4440shacryptshacrypt1.1Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
4450cryptintcryptint1.0.0Encryption functions for int and bigint values
4460pgueccpg_ecdsa1.0uECC bindings for Postgres
4470sparqlpgsparql1.0Query SPARQL datasource with SQL

gzip - 1.0.1

gzip and gunzip functions.

ExtensionWebsiteAttributes
Packagepg_gzip
RPMpgsql_gzip_$v*
DDL
DEBpostgresql-$v-gzip
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

bzip - 1.0.0

Bzip compression and decompression

ExtensionWebsiteAttributes
Packagepg_bzip
RPMpg_bzip_$v*
DDL
DEBpostgresql-$v-bzip
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

zstd - 1.1.2

Zstandard compression algorithm implementation in PostgreSQL

ExtensionWebsiteAttributes
Packagepg_zstd
RPMpg_zstd_$v*
DDL
DEBpostgresql-$v-zstd
LIB
Language
C
License
ISC
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

http - 1.6.3

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

ExtensionWebsiteAttributes
Packagepg_http
RPMpgsql_http_$v*
DDL
DEBpostgresql-$v-http
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_net - 0.9.2

Async HTTP Requests

ExtensionWebsiteAttributes
Packagepg_net
LOAD
RPMpg_net_$v*
DDL
DEBpostgresql-$v-pg-net
LIB
Language
C
License
Apache-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_curl - 2.4

Run curl actions for data transfer in URL syntax

ExtensionWebsiteAttributes
Packagepg_curl
RPMpg_curl_$v*
DDL
DEBpostgresql-$v-pg-curl
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgjq - 0.1.0

Use jq in Postgres

ExtensionWebsiteAttributes
Packagepgjq
RPMpgjq_$v*
DDL
DEBpostgresql-$v-pgjq
LIB
Language
C
License
MIT
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgjwt - 0.2.0

JSON Web Token API for Postgresql

ExtensionWebsiteAttributes
Packagepgjwt
RPMpgjwt_$v
DDL
DEBpostgresql-$v-pgjwt
LIB
Language
SQL
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_smtp_client - 0.2.0

PostgreSQL extension to send email using SMTP

ExtensionWebsiteAttributes
Packagepg_smtp_client
RPMpg_smtp_client_$v
DDL
DEBpostgresql-$v-pg-smtp-client
LIB
Language
Rust
License
MIT
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_html5_email_address - 1.2.3

PostgreSQL email validation that is consistent with the HTML5 spec

ExtensionWebsiteAttributes
Packagepg_html5_email_address
RPMpg_html5_email_address_$v
DDL
DEBpostgresql-$v-pg-html5-email-address
Language
SQL
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

url_encode - 1.2.5

url_encode, url_decode functions

ExtensionWebsiteAttributes
Packageurl_encode
RPMurl_encode_$v*
DDL
DEBpostgresql-$v-url-encode
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgsql_tweaks - 0.11.1

Some functions and views for daily usage

ExtensionWebsiteAttributes
Packagepgsql_tweaks
RPMpgsql_tweaks_$v
DDL
DEBpostgresql-$v-pgsql-tweaks
LIB
Language
SQL
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_extra_time - 2.0.0

Some date time functions and operators that,

ExtensionWebsiteAttributes
Packagepg_extra_time
RPMpg_extra_time_$v
DDL
DEBpostgresql-$v-pg-extra-time
LIB
Language
SQL
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgpcre - 1

Perl Compatible Regular Expression functions

ExtensionWebsiteAttributes
Packagepgpcre
RPMpgpcre_$v
DDL
DEBpostgresql-$v-pgpcre
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

icu_ext - 1.9.0

Access ICU functions

ExtensionWebsiteAttributes
Packageicu_ext
RPMicu_ext_$v*
DDL
DEBpostgresql-$v-icu-ext
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgqr - 1.0

QR Code generator from PostgreSQL

ExtensionWebsiteAttributes
Packagepgqr
RPMpgqr_$v*
DDL
DEBpostgresql-$v-pgqr
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_protobuf - 1.0

Protobuf support for PostgreSQL

ExtensionWebsiteAttributes
Packagepg_protobuf
RPMpg_protobuf_$v
DDL
DEBpostgresql-$v-pg-protobuf
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

envvar - 1.0.1

Fetch the value of an environment variable

ExtensionWebsiteAttributes
Packageenvvar
RPMpg_envvar_$v*
DDL
DEBpostgresql-$v-pg-envvar
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

floatfile - 1.3.1

Simple file storage for arrays of floats

ExtensionWebsiteAttributes
Packagefloatfile
RPMfloatfile_$v*
DDL
DEBpostgresql-$v-floatfile
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_render - 0.1.2

Render HTML in SQL

ExtensionWebsiteAttributes
Packagepg_render
RPMpg_render_$v
DDL
DEBpostgresql-$v-pg-render
LIB
Language
Rust
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_readme - 0.7.0

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

ExtensionWebsiteAttributes
Packagepg_readme
RPMpg_readme_$v
DDL
DEBpostgresql-$v-pg-readme
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_readme_test_extension - 0.7.0

Test generating a README.md document for extension or schema

ExtensionWebsiteAttributes
Packagepg_readme
RPMpg_readme_$v
DDL
DEBpostgresql-$v-pg-readme
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

ddl_historization - 0.0.7

Historize the ddl changes inside PostgreSQL database

ExtensionWebsiteAttributes
Packageddl_historization
RPMddl_historization_$v
DDL
DEBpostgresql-$v-ddl-historization
Language
SQL
License
GPL-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

data_historization - 1.1.0

PLPGSQL Script to historize data in partitionned table

ExtensionWebsiteAttributes
Packagedata_historization
RPMdata_historization_$v
DDL
DEBpostgresql-$v-data-historization
Language
SQL
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

schedoc - 0.0.1

Cross documentation between Django and DBT projects

ExtensionWebsiteAttributes
Packagepg_schedoc
RPMpg_schedoc_$v
DDL
DEBpostgresql-$v-pg-schedoc
Language
SQL
License
GPL-3.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hashlib - 1.1

Stable hash functions for Postgres

ExtensionWebsiteAttributes
Packagepg_hashlib
RPMpg_hashlib_$v
DDL
DEBpostgresql-$v-pg-hashlib
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

xxhash - 0.0.1

xxhash functions for PostgreSQL

ExtensionWebsiteAttributes
Packagepg_xxhash
RPMpg_xxhash_$v*
DDL
DEBpostgresql-$v-pg-xxhash
LIB
Language
C
License
BSD 2-Clause
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

shacrypt - 1.1

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

ExtensionWebsiteAttributes
Packageshacrypt
RPMpostgres_shacrypt_$v*
DDL
DEBpostgresql-$v-shacrypt
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

cryptint - 1.0.0

Encryption functions for int and bigint values

ExtensionWebsiteAttributes
Packagecryptint
RPMcryptint_$v*
DDL
DEBpostgresql-$v-cryptint
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pguecc - 1.0

uECC bindings for Postgres

ExtensionWebsiteAttributes
Packagepg_ecdsa
RPMpg_ecdsa_$v*
DDL
DEBpostgresql-$v-pg-ecdsa
LIB
Language
C
License
BSD 2-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

sparql - 1.0

Query SPARQL datasource with SQL

ExtensionWebsiteAttributes
Packagepgsparql
RPMpgsparql_$v
DDL
DEBpostgresql-$v-pgsparql
Language
SQL
License
Apache-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13