PostgreSQL™ includes several procedural languages with the base distribution: PL/pgSQL, PL/Tcl, PL/Perl, and PL/Python.
In addition, there are a number of procedural languages that are developed and maintained outside the core PostgreSQL™ distribution. Table H.2, “Externally Maintained Procedural Languages” lists some of these packages. Note that some of these projects might not be released under the same license as PostgreSQL™. For more information on each procedural language, including licensing information, refer to its website and documentation.
Table H.2. Externally Maintained Procedural Languages
Name | Language | Website |
---|---|---|
PL/Java | Java | http://pljava.projects.postgresql.org/ |
PL/PHP | PHP | http://www.commandprompt.com/community/plphp/ |
PL/Py | Python | http://python.projects.postgresql.org/backend/ |
PL/R | R | http://www.joeconway.com/plr/ |
PL/Ruby | Ruby | http://raa.ruby-lang.org/project/pl-ruby/ |
PL/Scheme | Scheme | http://plscheme.projects.postgresql.org/ |
PL/sh | Unix shell | http://plsh.projects.postgresql.org/ |