Contents
CREATE LANGUAGE
A DDL command for defining a new procedural language
CREATE LANGUAGE
is a DDL command for defining a new procedural language.
CREATE LANGUAGE
was added in PostgreSQL 6.3.
Usage
Normally procedural languages are installed by creating the extension which defines the language; CREATE LANGUAGE
is executed as part of the extension's installation script.
Change history
- PostgreSQL 14
- obsolete option to specify the language name as a single-quoted string removed (commit 5333e014)
- PostgreSQL 13
- removal of
pg_pltemplate
and creation of the concept of trusted extensions makes it possible for untrusted versions of non-core languages to be installed (commit 50fc694e)
- removal of
- PostgreSQL 9.0
- PostgreSQL 8.1
- simplified
CREATE LANGUAGE name
syntax added, which uses information stored inpg_pltemplate
to create the language (commits e0dedd05 and 48123de7)
- simplified
- PostgreSQL 7.3
- PostgreSQL 7.2
LANCOMPILER
option deprecated (commit ee8ed85d)
- PostgreSQL 6.3
- added as
CREATE PROCEDURAL LANGUAGE
(commit 7bff4c50)
- added as
References
- PostgreSQL documentation: CREATE LANGUAGE