WarehousePG bundles PL/pgSQL, PL/Perl, and PL/Python. It also supports PL/Java and PL/R, which you install separately.
Enabling bundled procedural languages
The bundled languages don't require a separate install. Enable each language with CREATE EXTENSION in the target database:
- PL/pgSQL:
CREATE EXTENSION plpgsql; - PL/Perl:
CREATE EXTENSION plperl; - PL/Python:
CREATE EXTENSION plpython3u;
Installing PL/Java and PL/R
Install PL/Java and PL/R on every host before you enable them. The EDB distribution of WarehousePG provides both as packages. See the installation instructions for each language, and then enable it:
Installing PL/R also gives you access to the R Data Science Library. See R Data Science Library for details.