plv8
PL/JavaScript (v8) trusted procedural language
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
plv8 | 3.2.4 | LANG | PostgreSQL | C++ |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 3010 | plv8 | No | Yes | No | Yes | No | No | pg_catalog |
| Related | plpgsql pg_jsonschema jsquery plperl plpython3u pg_tle pllua plluau |
|---|
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | PIGSTY | 3.2.4 | 1817161514 | plv8 | - |
| RPM | PIGSTY | 3.2.4 | 1817161514 | plv8_$v | - |
| DEB | PIGSTY | 3.2.4 | 1817161514 | postgresql-$v-plv8 | - |
| OS / PG | PG18 | PG17 | PG16 | PG15 | PG14 |
|---|---|---|---|---|---|
| el8.x86_64 | PIGSTY 3.2.4 el8.x86_64.pg18 : plv8_18 plv8_18-3.2.4-1PIGSTY.el8.x86_64.rpm
| PIGSTY 3.2.4 el8.x86_64.pg17 : plv8_17 plv8_17-3.2.4-1PIGSTY.el8.x86_64.rpm
| PIGSTY 3.2.4 el8.x86_64.pg16 : plv8_16 plv8_16-3.2.4-1PIGSTY.el8.x86_64.rpm
| PIGSTY 3.2.4 el8.x86_64.pg15 : plv8_15 plv8_15-3.2.4-1PIGSTY.el8.x86_64.rpm
| PIGSTY 3.2.4 el8.x86_64.pg14 : plv8_14 plv8_14-3.2.4-1PIGSTY.el8.x86_64.rpm
|
| el8.aarch64 | PIGSTY 3.2.4 el8.aarch64.pg18 : plv8_18 plv8_18-3.2.4-1PIGSTY.el8.aarch64.rpm
| PIGSTY 3.2.4 el8.aarch64.pg17 : plv8_17 plv8_17-3.2.4-1PIGSTY.el8.aarch64.rpm
| PIGSTY 3.2.4 el8.aarch64.pg16 : plv8_16 plv8_16-3.2.4-1PIGSTY.el8.aarch64.rpm
| PIGSTY 3.2.4 el8.aarch64.pg15 : plv8_15 plv8_15-3.2.4-1PIGSTY.el8.aarch64.rpm
| PIGSTY 3.2.4 el8.aarch64.pg14 : plv8_14 plv8_14-3.2.4-1PIGSTY.el8.aarch64.rpm
|
| el9.x86_64 | PIGSTY 3.2.4 el9.x86_64.pg18 : plv8_18 plv8_18-3.2.4-1PIGSTY.el9.x86_64.rpm
| PIGSTY 3.2.4 el9.x86_64.pg17 : plv8_17 plv8_17-3.2.4-1PIGSTY.el9.x86_64.rpm
| PIGSTY 3.2.4 el9.x86_64.pg16 : plv8_16 plv8_16-3.2.4-1PIGSTY.el9.x86_64.rpm
| PIGSTY 3.2.4 el9.x86_64.pg15 : plv8_15 plv8_15-3.2.4-1PIGSTY.el9.x86_64.rpm
| PIGSTY 3.2.4 el9.x86_64.pg14 : plv8_14 plv8_14-3.2.4-1PIGSTY.el9.x86_64.rpm
|
| el9.aarch64 | PIGSTY 3.2.4 el9.aarch64.pg18 : plv8_18 plv8_18-3.2.4-1PIGSTY.el9.aarch64.rpm
| PIGSTY 3.2.4 el9.aarch64.pg17 : plv8_17 plv8_17-3.2.4-1PIGSTY.el9.aarch64.rpm
| PIGSTY 3.2.4 el9.aarch64.pg16 : plv8_16 plv8_16-3.2.4-1PIGSTY.el9.aarch64.rpm
| PIGSTY 3.2.4 el9.aarch64.pg15 : plv8_15 plv8_15-3.2.4-1PIGSTY.el9.aarch64.rpm
| PIGSTY 3.2.4 el9.aarch64.pg14 : plv8_14 plv8_14-3.2.4-1PIGSTY.el9.aarch64.rpm
|
| el10.x86_64 | PIGSTY MISS | PIGSTY MISS | PIGSTY MISS | PIGSTY MISS | PIGSTY MISS |
| el10.aarch64 | PIGSTY MISS | PIGSTY MISS | PIGSTY MISS | PIGSTY MISS | PIGSTY MISS |
| d12.x86_64 | PIGSTY 3.2.4 d12.x86_64.pg18 : postgresql-18-plv8 postgresql-18-plv8_3.2.4-1PIGSTY~bookworm_amd64.deb
| PIGSTY 3.2.4 d12.x86_64.pg17 : postgresql-17-plv8 postgresql-17-plv8_3.2.4-1PIGSTY~bookworm_amd64.deb
| PIGSTY 3.2.4 d12.x86_64.pg16 : postgresql-16-plv8 postgresql-16-plv8_3.2.4-1PIGSTY~bookworm_amd64.deb
| PIGSTY 3.2.4 d12.x86_64.pg15 : postgresql-15-plv8 postgresql-15-plv8_3.2.4-1PIGSTY~bookworm_amd64.deb
| PIGSTY 3.2.4 d12.x86_64.pg14 : postgresql-14-plv8 postgresql-14-plv8_3.2.4-1PIGSTY~bookworm_amd64.deb
|
| d12.aarch64 | PIGSTY 3.2.4 d12.aarch64.pg18 : postgresql-18-plv8 postgresql-18-plv8_3.2.4-1PIGSTY~bookworm_arm64.deb
| PIGSTY 3.2.4 d12.aarch64.pg17 : postgresql-17-plv8 postgresql-17-plv8_3.2.4-1PIGSTY~bookworm_arm64.deb
| PIGSTY 3.2.4 d12.aarch64.pg16 : postgresql-16-plv8 postgresql-16-plv8_3.2.4-1PIGSTY~bookworm_arm64.deb
| PIGSTY 3.2.4 d12.aarch64.pg15 : postgresql-15-plv8 postgresql-15-plv8_3.2.4-1PIGSTY~bookworm_arm64.deb
| PIGSTY 3.2.4 d12.aarch64.pg14 : postgresql-14-plv8 postgresql-14-plv8_3.2.4-1PIGSTY~bookworm_arm64.deb
|
| d13.x86_64 | PIGSTY 3.2.4 d13.x86_64.pg18 : postgresql-18-plv8 postgresql-18-plv8_3.2.4-1PIGSTY~trixie_amd64.deb
| PIGSTY 3.2.4 d13.x86_64.pg17 : postgresql-17-plv8 postgresql-17-plv8_3.2.4-1PIGSTY~trixie_amd64.deb
| PIGSTY 3.2.4 d13.x86_64.pg16 : postgresql-16-plv8 postgresql-16-plv8_3.2.4-1PIGSTY~trixie_amd64.deb
| PIGSTY 3.2.4 d13.x86_64.pg15 : postgresql-15-plv8 postgresql-15-plv8_3.2.4-1PIGSTY~trixie_amd64.deb
| PIGSTY 3.2.4 d13.x86_64.pg14 : postgresql-14-plv8 postgresql-14-plv8_3.2.4-1PIGSTY~trixie_amd64.deb
|
| d13.aarch64 | PIGSTY 3.2.4 d13.aarch64.pg18 : postgresql-18-plv8 postgresql-18-plv8_3.2.4-1PIGSTY~trixie_arm64.deb
| PIGSTY 3.2.4 d13.aarch64.pg17 : postgresql-17-plv8 postgresql-17-plv8_3.2.4-1PIGSTY~trixie_arm64.deb
| PIGSTY 3.2.4 d13.aarch64.pg16 : postgresql-16-plv8 postgresql-16-plv8_3.2.4-1PIGSTY~trixie_arm64.deb
| PIGSTY 3.2.4 d13.aarch64.pg15 : postgresql-15-plv8 postgresql-15-plv8_3.2.4-1PIGSTY~trixie_arm64.deb
| PIGSTY 3.2.4 d13.aarch64.pg14 : postgresql-14-plv8 postgresql-14-plv8_3.2.4-1PIGSTY~trixie_arm64.deb
|
| u22.x86_64 | PIGSTY 3.2.4 u22.x86_64.pg18 : postgresql-18-plv8 postgresql-18-plv8_3.2.4-1PIGSTY~jammy_amd64.deb
| PIGSTY 3.2.4 u22.x86_64.pg17 : postgresql-17-plv8 postgresql-17-plv8_3.2.4-1PIGSTY~jammy_amd64.deb
| PIGSTY 3.2.4 u22.x86_64.pg16 : postgresql-16-plv8 postgresql-16-plv8_3.2.4-1PIGSTY~jammy_amd64.deb
| PIGSTY 3.2.4 u22.x86_64.pg15 : postgresql-15-plv8 postgresql-15-plv8_3.2.4-1PIGSTY~jammy_amd64.deb
| PIGSTY 3.2.4 u22.x86_64.pg14 : postgresql-14-plv8 postgresql-14-plv8_3.2.4-1PIGSTY~jammy_amd64.deb
|
| u22.aarch64 | PIGSTY 3.2.4 u22.aarch64.pg18 : postgresql-18-plv8 postgresql-18-plv8_3.2.4-1PIGSTY~jammy_arm64.deb
| PIGSTY 3.2.4 u22.aarch64.pg17 : postgresql-17-plv8 postgresql-17-plv8_3.2.4-1PIGSTY~jammy_arm64.deb
| PIGSTY 3.2.4 u22.aarch64.pg16 : postgresql-16-plv8 postgresql-16-plv8_3.2.4-1PIGSTY~jammy_arm64.deb
| PIGSTY 3.2.4 u22.aarch64.pg15 : postgresql-15-plv8 postgresql-15-plv8_3.2.4-1PIGSTY~jammy_arm64.deb
| PIGSTY 3.2.4 u22.aarch64.pg14 : postgresql-14-plv8 postgresql-14-plv8_3.2.4-1PIGSTY~jammy_arm64.deb
|
| u24.x86_64 | PIGSTY 3.2.4 u24.x86_64.pg18 : postgresql-18-plv8 postgresql-18-plv8_3.2.4-1PIGSTY~noble_amd64.deb
| PIGSTY 3.2.4 u24.x86_64.pg17 : postgresql-17-plv8 postgresql-17-plv8_3.2.4-1PIGSTY~noble_amd64.deb
| PIGSTY 3.2.4 u24.x86_64.pg16 : postgresql-16-plv8 postgresql-16-plv8_3.2.4-1PIGSTY~noble_amd64.deb
| PIGSTY 3.2.4 u24.x86_64.pg15 : postgresql-15-plv8 postgresql-15-plv8_3.2.4-1PIGSTY~noble_amd64.deb
| PIGSTY 3.2.4 u24.x86_64.pg14 : postgresql-14-plv8 postgresql-14-plv8_3.2.4-1PIGSTY~noble_amd64.deb
|
| u24.aarch64 | PIGSTY 3.2.4 u24.aarch64.pg18 : postgresql-18-plv8 postgresql-18-plv8_3.2.4-1PIGSTY~noble_arm64.deb
| PIGSTY 3.2.4 u24.aarch64.pg17 : postgresql-17-plv8 postgresql-17-plv8_3.2.4-1PIGSTY~noble_arm64.deb
| PIGSTY 3.2.4 u24.aarch64.pg16 : postgresql-16-plv8 postgresql-16-plv8_3.2.4-1PIGSTY~noble_arm64.deb
| PIGSTY 3.2.4 u24.aarch64.pg15 : postgresql-15-plv8 postgresql-15-plv8_3.2.4-1PIGSTY~noble_arm64.deb
| PIGSTY 3.2.4 u24.aarch64.pg14 : postgresql-14-plv8 postgresql-14-plv8_3.2.4-1PIGSTY~noble_arm64.deb
|
Build
You can build the RPM / DEB packages for plv8 using pig build:
pig build pkg plv8 # build RPM / DEB packages
Install
You can install plv8 directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:
pig repo add pgsql -u # Add repo and update cache
Install the extension using pig or apt/yum/dnf:
pig install plv8; # Install for current active PG version
pig ext install -y plv8 -v 18 # PG 18
pig ext install -y plv8 -v 17 # PG 17
pig ext install -y plv8 -v 16 # PG 16
pig ext install -y plv8 -v 15 # PG 15
pig ext install -y plv8 -v 14 # PG 14
dnf install -y plv8_18 # PG 18
dnf install -y plv8_17 # PG 17
dnf install -y plv8_16 # PG 16
dnf install -y plv8_15 # PG 15
dnf install -y plv8_14 # PG 14
apt install -y postgresql-18-plv8 # PG 18
apt install -y postgresql-17-plv8 # PG 17
apt install -y postgresql-16-plv8 # PG 16
apt install -y postgresql-15-plv8 # PG 15
apt install -y postgresql-14-plv8 # PG 14
Create Extension:
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']);
Build
Plv8 build breaks on EL10 (x86/arm) with the following problems:
- find g++ problem
- g++ 14 include
<algorithm>problem - lto problem, g++14 link time optimization issue
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.