Category: UTIL

• 1: zstd
• 2: gzip
• 3: http
• 4: pg_net
• 5: pg_curl
• 6: pgjq
• 7: pgjwt
• 8: pg_smtp_client
• 9: pg_html5_email_address
• 10: url_encode
• 11: pgsql_tweaks
• 12: pg_extra_time
• 13: pgpcre
• 14: icu_ext
• 15: pgqr
• 16: pg_protobuf
• 17: envvar
• 18: floatfile
• 19: pg_readme
• 20: ddl_historization
• 21: data_historization
• 22: schedoc
• 23: hashlib
• 24: xxhash
• 25: shacrypt
• 26: cryptint
• 27: pguecc
• 28: sparql

1 - zstd

Overview

PIGSTY 3rd Party Extension: pg_zstd : Zstandard compression algorithm implementation in PostgreSQL

Information

• Extension ID: 4000
• Extension Name: zstd
• Package Name: pg_zstd
• Category: UTIL
• License: ISC
• Website: https://github.com/grahamedgecombe/pgzstd
• Language: C
• Extra Tags: N/A
• Comment:

Metadata

• Latest Version: 1.1.0
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can not install to arbitrary schema
• Trusted: Unknown
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_zstd_$v*
• RPM Ver : 1.1.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-zstd
• DEB Ver : 1.1.0
• DEB Deps: N/A

Packages

Installation

Install zstd via the pig CLI tool:

pig ext install pg_zstd; # Extension Namepig ext install zstd; # normalized package name

Install pg_zstd via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_zstd"]}' # -l <cls>

Install pg_zstd RPM from YUM repo directly:

dnf install pg_zstd_17*;
dnf install pg_zstd_16*;
dnf install pg_zstd_15*;
dnf install pg_zstd_14*;
dnf install pg_zstd_13*;

Install pg_zstd DEB from APT repo directly:

apt install postgresql-17-pg-zstd;
apt install postgresql-16-pg-zstd;
apt install postgresql-15-pg-zstd;
apt install postgresql-14-pg-zstd;
apt install postgresql-13-pg-zstd;

Enable zstd extension on PostgreSQL cluster：

CREATE EXTENSION zstd;

Usage

zstd_compress compresses the provided data and returns a Zstandard frame. A preset dictionary may also be provided. The default compression level may also be overriden, valid values range from 1 (best speed) to 22 (best compression). The default level is 3.

If you want to override the compression level without using a dictionary, set dictionary to NULL.

zstd_decompress decompresses the provided Zstandard frame in data and returns the uncompressed data. A preset dictionary, matching the dictionary used to compress the data, may also be provided.

zstd_length returns the decompressed length of the provided Zstandard frame. If ZSTD_getFrameContentSize() is available it returns NULL if the length is unknown. If unavailable, it isn’t possible to distinguish the error, unknown decompressed length and zero decompressed length cases.

Example

Basic compress/decompress example:

CREATE EXTENSION zstd;

SELECT zstd_compress('hello world');
-- zstd_compress
-- --------------------------------------------
-- \x28b52ffd200b59000068656c6c6f20776f726c64

SELECT convert_from(zstd_decompress('\x28b52ffd200b59000068656c6c6f20776f726c64'), 'utf-8');
-- convert_from
-- --------------
--  hello world

Compress with level (1 for best speed, 22 for best compression, default to 3)

CREATE EXTENSION zstd;

SELECT zstd_compress('hello world',  NULL, 10);
-- zstd_compress
-- --------------------------------------------
-- \x28b52ffd200b59000068656c6c6f20776f726c64

SELECT convert_from(zstd_decompress('\x28b52ffd200b59000068656c6c6f20776f726c64'), 'utf-8');
-- convert_from
-- --------------
--  hello world

2 - gzip

Overview

MIXED 3rd Party Extension: pg_gzip : gzip and gunzip functions.

Information

• Extension ID: 4010
• Extension Name: gzip
• Package Name: pg_gzip
• Category: UTIL
• License: MIT
• Website: https://github.com/pramsey/pgsql-gzip
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.0
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can not install to arbitrary schema
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PGDG
• RPM Name: pgsql_gzip_$v*
• RPM Ver : 1.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-gzip
• DEB Ver : 1.0
• DEB Deps: N/A

Packages

Installation

Install gzip via the pig CLI tool:

pig ext install pg_gzip; # Extension Namepig ext install gzip; # normalized package name

Install pg_gzip via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_gzip"]}' # -l <cls>

Install pg_gzip RPM from YUM repo directly:

dnf install pgsql_gzip_17*;
dnf install pgsql_gzip_16*;
dnf install pgsql_gzip_15*;
dnf install pgsql_gzip_14*;
dnf install pgsql_gzip_13*;

Install pg_gzip DEB from APT repo directly:

apt install postgresql-17-gzip;
apt install postgresql-16-gzip;
apt install postgresql-15-gzip;
apt install postgresql-14-gzip;
apt install postgresql-13-gzip;

Enable gzip extension on PostgreSQL cluster：

CREATE EXTENSION gzip;

Usage

Sometimes you just need to compress your bytea object before you return it to the client.

Sometimes you receive a compressed bytea from the client, and you have to uncompress it before you can work with it.

This extension is for that.

This extension is not for storage compression. PostgreSQL already does tuple compression on the fly if your tuple gets large enough, manually pre-compressing your data using this function won’t make things smaller.

• gzip(uncompressed BYTEA, [compression_level INTEGER]) returns BYTEA
• gzip(uncompressed TEXT, [compression_level INTEGER]) returns BYTEA
• gunzip(compressed BYTEA) returns BYTEA

Examples

> SELECT gzip('this is my this is my this is my this is my text');

                                   gzip
--------------------------------------------------------------------------
 \x1f8b08000000000000132bc9c82c5600a2dc4a851282ccd48a12002e7a22ff30000000

Wait, what, the compressed output is longer?!? No, it only looks that way, because in hex every byte is represented with two hex digits. The original string looks like this in hex:

> SELECT 'this is my this is my this is my this is my text'::bytea;

                                               bytea
----------------------------------------------------------------------------------------------------
 \x74686973206973206d792074686973206973206d792074686973206973206d792074686973206973206d792074657874

For really long, repetitive things, compression naturally works like a charm:

> SELECT gzip(repeat('this is my ', 100));

                                               bytea
----------------------------------------------------------------------------------------------------
 \x1f8b08000000000000132bc9c82c5600a2dc4a859251e628739439ca24970900d1341c5c4c040000

To convert a bytea back into an equivalent text you must use the encode() function with the escape encoding.

> SELECT encode('test text'::bytea, 'escape');
   encode
-----------
 test text

> SELECT encode(gunzip(gzip('this text has been compressed and then decompressed')), 'escape')

                      encode
-----------------------------------------------------
 this text has been compressed and then decompressed

3 - http

Overview

PGDG 1st Party Extension: pg_http : HTTP client for PostgreSQL, allows web page retrieval inside the database.

Information

• Extension ID: 4020
• Extension Name: http
• Package Name: pg_http
• Category: UTIL
• License: MIT
• Website: https://github.com/pramsey/pgsql-http
• Language: C
• Extra Tags: supabase
• Comment: N/A

Metadata

• Latest Version: 1.6
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Unknown
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PGDG
• RPM Name: pgsql_http_$v*
• RPM Ver : 1.6
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-http
• DEB Ver : 1.6
• DEB Deps: N/A

Packages

Installation

Install http via the pig CLI tool:

pig ext install pg_http; # Extension Namepig ext install http; # normalized package name

Install pg_http via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_http"]}' # -l <cls>

Install pg_http RPM from YUM repo directly:

dnf install pgsql_http_17*;
dnf install pgsql_http_16*;
dnf install pgsql_http_15*;
dnf install pgsql_http_14*;
dnf install pgsql_http_13*;

Install pg_http DEB from APT repo directly:

apt install postgresql-17-http;
apt install postgresql-16-http;
apt install postgresql-15-http;
apt install postgresql-14-http;
apt install postgresql-13-http;

Enable http extension on PostgreSQL cluster：

CREATE EXTENSION http;

Usage

https://github.com/pramsey/pgsql-http

Request / Response Schema:

     Composite type "public.http_request"
    Column    |       Type        | Modifiers
--------------+-------------------+-----------
 method       | http_method       |
 uri          | character varying |
 headers      | http_header[]     |
 content_type | character varying |
 content      | character varying |

    Composite type "public.http_response"
    Column    |       Type        | Modifiers
--------------+-------------------+-----------
 status       | integer           |
 content_type | character varying |
 headers      | http_header[]     |
 content      | character varying |

Examples

Sending HTTP GET requests with SQL

CREATE EXTENSION http;

-- get content
SELECT content FROM http_get('http://httpbun.com/');

-- get status and content_type
SELECT status, content_type FROM http_get('http://httpbun.com/');

--  status |       content_type
-- --------+--------------------------
--     200 | text/html; charset=utf-8

-- get headers
SELECT (unnest(headers)).* FROM http_get('http://httpbun.com/');

--             field           |                      value
--  ---------------------------+--------------------------------------------------
--  Location                  | https://httpbun.com/
--  Date                      | Mon, 04 Nov 2024 09:00:36 GMT
--  Content-Length            | 0
--  Connection                | close
--  alt-svc                   | h3=":443"; ma=2592000
--  content-security-policy   | frame-ancestors 'none'
--  content-type              | text/html
--  date                      | Mon, 04 Nov 2024 09:00:37 GMT
--  strict-transport-security | max-age=31536000; includeSubDomains; preload
--  x-content-type-options    | nosniff
--  x-powered-by              | httpbun/af040d24038613575a85f74c2283ae79f8169927
--  (11 rows)

SELECT status, content::json->'form' AS form FROM http_post('http://httpbun.com/post', jsonb_build_object('myvar','myval','foo','bar'));

Issue http put requests:

SELECT status, content_type, content::json->>'data' AS data
  FROM http_put('http://httpbun.com/put', 'some text', 'text/plain');


--  status |   content_type   |   data
-- --------+------------------+-----------
--  200 | application/json | some text

Issue http post request:

4 - pg_net

Overview

PIGSTY 3rd Party Extension: pg_net : Async HTTP Requests

Information

• Extension ID: 4030
• Extension Name: pg_net
• Package Name: pg_net
• Category: UTIL
• License: Apache-2.0
• Website: https://github.com/supabase/pg_net
• Language: C
• Extra Tags: supabase
• Comment: N/A

Metadata

• Latest Version: 0.8.0
• Postgres Support: 17,16,15,14,13
• Need Load: Explicit Loading Required
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_net_$v*
• RPM Ver : 0.8.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-net
• DEB Ver : 0.8.0
• DEB Deps: N/A

Packages

Installation

Install pg_net via the pig CLI tool:

pig ext install pg_net

Install pg_net via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_net"]}' # -l <cls>

Install pg_net RPM from YUM repo directly:

dnf install pg_net_17*;
dnf install pg_net_16*;
dnf install pg_net_15*;
dnf install pg_net_14*;
dnf install pg_net_13*;

Install pg_net DEB from APT repo directly:

apt install postgresql-17-pg-net;
apt install postgresql-16-pg-net;
apt install postgresql-15-pg-net;
apt install postgresql-14-pg-net;
apt install postgresql-13-pg-net;

Extension pg_net has to be added to shared_preload_libraries

shared_preload_libraries = 'pg_net'; # add to pg cluster config

Enable pg_net extension on PostgreSQL cluster：

CREATE EXTENSION pg_net;

5 - pg_curl

Overview

PIGSTY 3rd Party Extension: pg_curl : Run curl actions for data transfer in URL syntax

Information

• Extension ID: 4040
• Extension Name: pg_curl
• Package Name: pg_curl
• Category: UTIL
• License: MIT
• Website: https://github.com/RekGRpth/pg_curl
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 2.4
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can not install to arbitrary schema
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_curl_$v*
• RPM Ver : 2.4
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-curl
• DEB Ver : 2.4
• DEB Deps: N/A

Packages

Installation

Install pg_curl via the pig CLI tool:

pig ext install pg_curl

Install pg_curl via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_curl"]}' # -l <cls>

Install pg_curl RPM from YUM repo directly:

dnf install pg_curl_17*;
dnf install pg_curl_16*;
dnf install pg_curl_15*;
dnf install pg_curl_14*;
dnf install pg_curl_13*;

Install pg_curl DEB from APT repo directly:

apt install postgresql-17-pg-curl;
apt install postgresql-16-pg-curl;
apt install postgresql-15-pg-curl;
apt install postgresql-14-pg-curl;
apt install postgresql-13-pg-curl;

Enable pg_curl extension on PostgreSQL cluster：

CREATE EXTENSION pg_curl;

Usage

CREATE EXTENSION pg_curl;

Perform HTTP Get:

-- wrap curl http get
CREATE OR REPLACE FUNCTION get(url TEXT) RETURNS TEXT LANGUAGE SQL AS $BODY$
WITH s AS (SELECT
               curl_easy_reset(),
               curl_easy_setopt_url(url),
               curl_easy_perform(),
               curl_easy_getinfo_data_in()
) SELECT convert_from(curl_easy_getinfo_data_in, 'utf-8') FROM s;
$BODY$;


SELECT get('https://www.postgresql.org/');

Perform Email SMTP:

CREATE OR REPLACE FUNCTION email(url TEXT, username TEXT, password TEXT, subject TEXT, sender TEXT, recipient TEXT, body TEXT, type TEXT) RETURNS TEXT LANGUAGE SQL AS $BODY$
    WITH s AS (SELECT
        curl_easy_reset(),
        curl_easy_setopt_mail_from(sender),
        curl_easy_setopt_password(password),
        curl_easy_setopt_url(url),
        curl_easy_setopt_username(username),
        curl_header_append('From', sender),
        curl_header_append('Subject', subject),
        curl_header_append('To', recipient),
        curl_mime_data(body, type:=type),
        curl_recipient_append(recipient),
        curl_easy_perform(),
        curl_easy_getinfo_header_in()
    ) SELECT curl_easy_getinfo_header_in FROM s;
$BODY$;

Perform FTP download:

CREATE OR REPLACE FUNCTION download(url TEXT, username TEXT, password TEXT) RETURNS BYTEA LANGUAGE SQL AS $BODY$
    WITH s AS (SELECT
        curl_easy_reset(),
        curl_easy_setopt_password(password),
        curl_easy_setopt_url(url),
        curl_easy_setopt_username(username),
        curl_easy_perform(),
        curl_easy_getinfo_data_in()
    ) SELECT curl_easy_getinfo_data_in FROM s;
$BODY$;

6 - pgjq

Overview

PIGSTY 3rd Party Extension: pgjq : Use jq in Postgres

Information

• Extension ID: 4050
• Extension Name: pgjq
• Package Name: pgjq
• Category: UTIL
• License: MIT
• Website: https://github.com/Florents-Tselai/pgJQ
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 0.1.0
• Postgres Support: 17,16,15,14
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can not install to arbitrary schema
• Trusted: Trusted, Can be created by user with CREATE Privilege
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pgjq_$v*
• RPM Ver : 0.1.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pgjq
• DEB Ver : 0.1.0
• DEB Deps: N/A

Packages

Installation

Install pgjq via the pig CLI tool:

pig ext install pgjq

Install pgjq via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgjq"]}' # -l <cls>

Install pgjq RPM from YUM repo directly:

dnf install pgjq_17*;
dnf install pgjq_16*;
dnf install pgjq_15*;
dnf install pgjq_14*;

Install pgjq DEB from APT repo directly:

apt install postgresql-17-pgjq;
apt install postgresql-16-pgjq;
apt install postgresql-15-pgjq;
apt install postgresql-14-pgjq;

Enable pgjq extension on PostgreSQL cluster：

CREATE EXTENSION pgjq;

7 - pgjwt

Overview

PIGSTY 3rd Party Extension: pgjwt : JSON Web Token API for Postgresql

Information

• Extension ID: 4060
• Extension Name: pgjwt
• Package Name: pgjwt
• Category: UTIL
• License: MIT
• Website: https://github.com/michelp/pgjwt
• Language: SQL
• Extra Tags: supabase
• Comment: N/A

Metadata

• Latest Version: 0.2.0
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Unknown
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pgjwt_$v
• RPM Ver : 0.2.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pgjwt
• DEB Ver : 0.2.0
• DEB Deps: N/A

Packages

Installation

Install pgjwt via the pig CLI tool:

pig ext install pgjwt

Install pgjwt via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgjwt"]}' # -l <cls>

Install pgjwt RPM from YUM repo directly:

dnf install pgjwt_17;
dnf install pgjwt_16;
dnf install pgjwt_15;
dnf install pgjwt_14;
dnf install pgjwt_13;

Install pgjwt DEB from APT repo directly:

apt install postgresql-17-pgjwt;
apt install postgresql-16-pgjwt;
apt install postgresql-15-pgjwt;
apt install postgresql-14-pgjwt;
apt install postgresql-13-pgjwt;

Enable pgjwt extension on PostgreSQL cluster：

CREATE EXTENSION pgjwt;

8 - pg_smtp_client

Overview

PIGSTY 3rd Party Extension: pg_smtp_client : PostgreSQL extension to send email using SMTP

Information

• Extension ID: 4070
• Extension Name: pg_smtp_client
• Package Name: pg_smtp_client
• Category: UTIL
• License: MIT
• Website: https://github.com/brianpursley/pg_smtp_client
• Language: Rust
• Extra Tags: pgrx
• Comment: N/A

Metadata

• Latest Version: 0.2.0
• Postgres Support: 17,16,15,14
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Trusted, Can be created by user with CREATE Privilege
• Schemas: smtp_client
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_smtp_client_$v
• RPM Ver : 0.2.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-smtp-client
• DEB Ver : 0.2.0
• DEB Deps: N/A

Packages

Installation

Install pg_smtp_client via the pig CLI tool:

pig ext install pg_smtp_client

Install pg_smtp_client via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_smtp_client"]}' # -l <cls>

Install pg_smtp_client RPM from YUM repo directly:

dnf install pg_smtp_client_17;
dnf install pg_smtp_client_16;
dnf install pg_smtp_client_15;
dnf install pg_smtp_client_14;

Install pg_smtp_client DEB from APT repo directly:

apt install postgresql-17-pg-smtp-client;
apt install postgresql-16-pg-smtp-client;
apt install postgresql-15-pg-smtp-client;
apt install postgresql-14-pg-smtp-client;

Enable pg_smtp_client extension on PostgreSQL cluster：

CREATE EXTENSION pg_smtp_client;

Usage

https://github.com/frectonz/pglite-fusion/blob/main/README.md

Enabling the extension

Connect to postgres and run the following command.

CREATE EXTENSION IF NOT EXISTS pg_smtp_client CASCADE;

Usage

Use the smtp_client.send_email() function to send an email.

Function Parameters

Default Configuration

You can configure the following system-wide default values for some of the parameters (as indiciated in the table above) like this:

ALTER SYSTEM SET smtp_client.server TO 'smtp.example.com';
ALTER SYSTEM SET smtp_client.port TO 587;
ALTER SYSTEM SET smtp_client.tls TO true;
ALTER SYSTEM SET smtp_client.username TO 'MySmtpUsername';
ALTER SYSTEM SET smtp_client.password TO 'MySmtpPassword';
ALTER SYSTEM SET smtp_client.from_address TO '[email protected]';
SELECT pg_reload_conf();

Usage Examples

Send an email:

SELECT smtp_client.send_email('test subject', 'test body', false, '[email protected]', array['[email protected]'], null, null, 'smtp.example.com', 587, true, 'username', 'password');

Send an email using configured default values:

SELECT smtp_client.send_email('test subject', 'test body', false, null, array['[email protected]']);

Or, using named arguments:

SELECT smtp_client.send_email('test subject', 'test body', recipients => array['[email protected]']);

9 - pg_html5_email_address

Overview

PIGSTY 3rd Party Extension: pg_html5_email_address : PostgreSQL email validation that is consistent with the HTML5 spec

Information

• Extension ID: 4080
• Extension Name: pg_html5_email_address
• Package Name: pg_html5_email_address
• Category: UTIL
• License: PostgreSQL
• Website: https://github.com/bigsmoke/pg_html5_email_address
• Language: SQL
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.2.3
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can not install to arbitrary schema
• Trusted: Unknown
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_html5_email_address_$v
• RPM Ver : 1.2.3
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-html5-email-address
• DEB Ver : 1.2.3
• DEB Deps: N/A

Packages

Installation

Install pg_html5_email_address via the pig CLI tool:

pig ext install pg_html5_email_address

Install pg_html5_email_address via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_html5_email_address"]}' # -l <cls>

Install pg_html5_email_address RPM from YUM repo directly:

dnf install pg_html5_email_address_17;
dnf install pg_html5_email_address_16;
dnf install pg_html5_email_address_15;
dnf install pg_html5_email_address_14;
dnf install pg_html5_email_address_13;

Install pg_html5_email_address DEB from APT repo directly:

apt install postgresql-17-pg-html5-email-address;
apt install postgresql-16-pg-html5-email-address;
apt install postgresql-15-pg-html5-email-address;
apt install postgresql-14-pg-html5-email-address;
apt install postgresql-13-pg-html5-email-address;

Enable pg_html5_email_address extension on PostgreSQL cluster：

CREATE EXTENSION pg_html5_email_address;

10 - url_encode

Overview

PIGSTY 3rd Party Extension: url_encode : url_encode, url_decode functions

Information

• Extension ID: 4090
• Extension Name: url_encode
• Package Name: url_encode
• Category: UTIL
• License: PostgreSQL
• Website: https://github.com/okbob/url_encode
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.2
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can not install to arbitrary schema
• Trusted: Unknown
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: url_encode_$v*
• RPM Ver : 1.2
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-url-encode
• DEB Ver : 1.2
• DEB Deps: N/A

Packages