Category: LANG

• 1: pg_tle
• 2: plv8
• 3: pllua
• 4: hstore_pllua
• 5: plluau
• 6: hstore_plluau
• 7: plprql
• 8: pldbgapi
• 9: plpgsql_check
• 10: plprofiler
• 11: plsh
• 12: pljava
• 13: plr
• 14: pgtap
• 15: faker
• 16: dbt2
• 17: pltcl
• 18: pltclu
• 19: plperl
• 20: bool_plperl
• 21: hstore_plperl
• 22: jsonb_plperl
• 23: plperlu
• 24: bool_plperlu
• 25: jsonb_plperlu
• 26: hstore_plperlu
• 27: plpgsql
• 28: plpython3u
• 29: jsonb_plpython3u
• 30: ltree_plpython3u
• 31: hstore_plpython3u

1 - pg_tle

Overview

PIGSTY 3rd Party Extension: pg_tle : Trusted Language Extensions for PostgreSQL

Information

• Extension ID: 3000
• Extension Name: pg_tle
• Package Name: pg_tle
• Category: LANG
• License: Apache-2.0
• Website: https://github.com/aws/pg_tle
• Language: C
• Extra Tags: both
• Comment: N/A

Metadata

• Latest Version: 1.2.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: pgtle
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_tle_$v*
• RPM Ver : 1.2.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-tle
• DEB Ver : 1.4.0
• DEB Deps: N/A

Packages

Installation

Install pg_tle via the pig CLI tool:

pig ext install pg_tle

Install pg_tle via Pigsty playbook:

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

Install pg_tle RPM from YUM repo directly:

dnf install pg_tle_17*;
dnf install pg_tle_16*;
dnf install pg_tle_15*;
dnf install pg_tle_14*;
dnf install pg_tle_13*;

Install pg_tle DEB from APT repo directly:

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

Extension pg_tle has to be added to shared_preload_libraries

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

Enable pg_tle extension on PostgreSQL cluster：

CREATE EXTENSION pg_tle;

2 - plv8

Overview

PIGSTY 3rd Party Extension: plv8 : PL/JavaScript (v8) trusted procedural language

Information

• Extension ID: 3010
• Extension Name: plv8
• Package Name: plv8
• Category: LANG
• License: PostgreSQL
• Website: https://github.com/plv8/plv8
• Language: C++
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 3.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 be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: pg_catalog
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: plv8_$v*
• RPM Ver : 3.2.3
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-plv8
• DEB Ver : 3.2.3
• DEB Deps: N/A

Packages

Installation

Install plv8 via the pig CLI tool:

pig ext install plv8

Install plv8 via Pigsty playbook:

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

Install plv8 RPM from YUM repo directly:

dnf install plv8_17*;
dnf install plv8_16*;
dnf install plv8_15*;
dnf install plv8_14*;
dnf install plv8_13*;

Install plv8 DEB from APT repo directly:

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

Enable plv8 extension on PostgreSQL cluster：

CREATE EXTENSION plv8;

Usage

CREATE EXTENSION plv8;

SELECT plv8_version();
SELECT plv8_info();

DO $$ plv8.elog(NOTICE, plv8.version); $$ LANGUAGE plv8;

Example:

CREATE FUNCTION plv8_test(keys TEXT[], vals TEXT[]) RETURNS JSON AS $$
    var o = {};
    for(var i=0; i<keys.length; i++){
        o[keys[i]] = vals[i];
    }
    return o;
$$ LANGUAGE plv8 IMMUTABLE STRICT;


SELECT plv8_test(ARRAY['name', 'age'], ARRAY['Tom', '29']);

3 - pllua

Overview

PGDG 1st Party Extension: pllua : Lua as a procedural language

Information

• Extension ID: 3020
• Extension Name: pllua
• Package Name: pllua
• Category: LANG
• License: MIT
• Website: https://github.com/pllua/pllua
• Language: C
• Extra Tags: N/A
• Comment:

Metadata

• Latest Version: 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: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: pg_catalog
• Requires: N/A

RPM / DEB

• RPM Repo: PGDG
• RPM Name: pllua_$v*
• RPM Ver : 2.0
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-pllua
• DEB Ver : 2.0
• DEB Deps: N/A

Packages

Installation

Install pllua via the pig CLI tool:

pig ext install pllua

Install pllua via Pigsty playbook:

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

Install pllua RPM from YUM repo directly:

dnf install pllua_17*;
dnf install pllua_16*;
dnf install pllua_15*;
dnf install pllua_14*;
dnf install pllua_13*;

Install pllua DEB from APT repo directly:

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

Enable pllua extension on PostgreSQL cluster：

CREATE EXTENSION pllua;

4 - hstore_pllua

Overview

PGDG 1st Party Extension: pllua : Hstore transform for Lua

Information

• Extension ID: 3021
• Extension Name: hstore_pllua
• Package Name: pllua
• Category: LANG
• License: MIT
• Website: https://github.com/pllua/pllua
• Language: C
• Extra Tags: N/A
• Comment:

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: hstore, pllua

RPM / DEB

• RPM Repo: None
• RPM Name: N/A
• RPM Ver : N/A
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-pllua
• DEB Ver : 1.0
• DEB Deps: N/A

Packages

Installation

Install hstore_pllua via the pig CLI tool:

pig ext install pllua; # Extension Namepig ext install hstore_pllua; # normalized package name

Install pllua via Pigsty playbook:

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

Install pllua DEB from APT repo directly:

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

Enable hstore_pllua extension on PostgreSQL cluster：

CREATE EXTENSION hstore_pllua CASCADE;

5 - plluau

Overview

PGDG 1st Party Extension: pllua : Lua as an untrusted procedural language

Information

• Extension ID: 3030
• Extension Name: plluau
• Package Name: pllua
• Category: LANG
• License: MIT
• Website: https://github.com/pllua/pllua
• Language: C
• Extra Tags: N/A
• Comment:

Metadata

• Latest Version: 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: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: pg_catalog
• Requires: N/A

RPM / DEB

• RPM Repo: PGDG
• RPM Name: pllua_$v*
• RPM Ver : 2.0
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-pllua
• DEB Ver : 2.0
• DEB Deps: N/A

Packages

Installation

Install plluau via the pig CLI tool:

pig ext install pllua; # Extension Namepig ext install plluau; # normalized package name

Install pllua via Pigsty playbook:

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

Install pllua RPM from YUM repo directly:

dnf install pllua_17*;
dnf install pllua_16*;
dnf install pllua_15*;
dnf install pllua_14*;
dnf install pllua_13*;

Install pllua DEB from APT repo directly:

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

Enable plluau extension on PostgreSQL cluster：

CREATE EXTENSION plluau;

6 - hstore_plluau

Overview

PGDG 1st Party Extension: pllua : Hstore transform for untrusted Lua

Information

• Extension ID: 3031
• Extension Name: hstore_plluau
• Package Name: pllua
• Category: LANG
• License: MIT
• Website: https://github.com/pllua/pllua
• Language: C
• Extra Tags: N/A
• Comment:

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: pg_catalog
• Requires: hstore, plluau

RPM / DEB

• RPM Repo: None
• RPM Name: N/A
• RPM Ver : N/A
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-pllua
• DEB Ver : 1.0
• DEB Deps: N/A

Packages

Installation

Install hstore_plluau via the pig CLI tool:

pig ext install pllua; # Extension Namepig ext install hstore_plluau; # normalized package name

Install pllua via Pigsty playbook:

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

Install pllua DEB from APT repo directly:

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

Enable hstore_plluau extension on PostgreSQL cluster：

CREATE EXTENSION hstore_plluau CASCADE;

7 - plprql

Overview

PIGSTY 3rd Party Extension: plprql : Use PRQL in PostgreSQL - Pipelined Relational Query Language

Information

• Extension ID: 3040
• Extension Name: plprql
• Package Name: plprql
• Category: LANG
• License: Apache-2.0
• Website: https://github.com/kaspermarstal/plprql
• Language: Rust
• Extra Tags: pgrx
• Comment: N/A

Metadata

• Latest Version: 1.0.0
• Postgres Support: 16,15,14,13
• Need Load: Shared library do not need explicit loading
• 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: plprql_$v
• RPM Ver : 1.0.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-plprql
• DEB Ver : 1.0.0
• DEB Deps: N/A

Packages

Installation

Install plprql via the pig CLI tool:

pig ext install plprql

Install plprql via Pigsty playbook:

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

Install plprql RPM from YUM repo directly:

dnf install plprql_16;
dnf install plprql_15;
dnf install plprql_14;
dnf install plprql_13;

Install plprql DEB from APT repo directly:

apt install postgresql-16-plprql;
apt install postgresql-15-plprql;
apt install postgresql-14-plprql;
apt install postgresql-13-plprql;

Enable plprql extension on PostgreSQL cluster：

CREATE EXTENSION plprql;

8 - pldbgapi

Overview

PGDG 1st Party Extension: pldebugger : server-side support for debugging PL/pgSQL functions

Information

• Extension ID: 3050
• Extension Name: pldbgapi
• Package Name: pldebugger
• Category: LANG
• License: Artistic
• Website: https://github.com/EnterpriseDB/pldebugger
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.1
• 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: pldebugger_$v*
• RPM Ver : 1.1
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-pldebugger
• DEB Ver : 1.1
• DEB Deps: N/A

Packages

Installation

Install pldbgapi via the pig CLI tool:

pig ext install pldebugger; # Extension Namepig ext install pldbgapi; # normalized package name

Install pldebugger via Pigsty playbook:

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

Install pldebugger RPM from YUM repo directly:

dnf install pldebugger_17*;
dnf install pldebugger_16*;
dnf install pldebugger_15*;
dnf install pldebugger_14*;
dnf install pldebugger_13*;

Install pldebugger DEB from APT repo directly:

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

Enable pldbgapi extension on PostgreSQL cluster：

CREATE EXTENSION pldbgapi;

9 - plpgsql_check

Overview

PGDG 1st Party Extension: plpgsql_check : extended check for plpgsql functions

Information

• Extension ID: 3060
• Extension Name: plpgsql_check
• Package Name: plpgsql_check
• Category: LANG
• License: MIT
• Website: https://github.com/okbob/plpgsql_check
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 2.7
• 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: plpgsql

RPM / DEB

• RPM Repo: PGDG
• RPM Name: plpgsql_check_$v*
• RPM Ver : 2.7
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-plpgsql-check
• DEB Ver : 2.7
• DEB Deps: N/A

Packages

Installation

Install plpgsql_check via the pig CLI tool:

pig ext install plpgsql_check

Install plpgsql_check via Pigsty playbook:

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

Install plpgsql_check RPM from YUM repo directly:

dnf install plpgsql_check_17*;
dnf install plpgsql_check_16*;
dnf install plpgsql_check_15*;
dnf install plpgsql_check_14*;
dnf install plpgsql_check_13*;

Install plpgsql_check DEB from APT repo directly:

apt install postgresql-17-plpgsql-check;
apt install postgresql-16-plpgsql-check;
apt install postgresql-15-plpgsql-check;
apt install postgresql-14-plpgsql-check;
apt install postgresql-13-plpgsql-check;

Extension plpgsql_check has to be added to shared_preload_libraries

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

Enable plpgsql_check extension on PostgreSQL cluster：

CREATE EXTENSION plpgsql_check CASCADE;

10 - plprofiler

Overview

PGDG 1st Party Extension: plprofiler : server-side support for profiling PL/pgSQL functions

Information

• Extension ID: 3070
• Extension Name: plprofiler
• Package Name: plprofiler
• Category: LANG
• License: Artistic
• Website: https://github.com/bigsql/plprofiler
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 4.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: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PGDG
• RPM Name: plprofiler_$v*
• RPM Ver : 4.2
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-plprofiler
• DEB Ver : 4.2
• DEB Deps: N/A

Packages

Installation

Install plprofiler via the pig CLI tool:

pig ext install plprofiler

Install plprofiler via Pigsty playbook:

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

Install plprofiler RPM from YUM repo directly:

dnf install plprofiler_17*;
dnf install plprofiler_16*;
dnf install plprofiler_15*;
dnf install plprofiler_14*;
dnf install plprofiler_13*;

Install plprofiler DEB from APT repo directly:

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

Enable plprofiler extension on PostgreSQL cluster：

CREATE EXTENSION plprofiler;

11 - plsh

Overview

PGDG 1st Party Extension: plsh : PL/sh procedural language

Information

• Extension ID: 3080
• Extension Name: plsh
• Package Name: plsh
• Category: LANG
• License: MIT
• Website: https://github.com/petere/plsh
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 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: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PGDG
• RPM Name: plsh_$v*
• RPM Ver : 2
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-plsh
• DEB Ver : 2
• DEB Deps: N/A

Packages