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 G-2 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 G-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/ |
| 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/ |