Template procedural languages

Template procedural languages are used to register a new language in a convenient way. There are two ways to create a programming language; the first way is by specifying only the name of the programming language. In this method, PostgreSQL consults the programming language template and determines the parameters. The second way is to specify the name as well as the parameters. The SQL command to create a language is CREATE LANGUAGE.

In PostgreSQL versions 9.1 and later, CREATE EXTENSION can be used to install a programming language. The template procedural languages are maintained in the table pg_pltemplate. This table might be decommissioned in favor of keeping the procedural language information in their installation scripts.