pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / C

• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (dev)
  • PostgreSQL 14 (latest)
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

CREATE 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)
• PostgreSQL 9.0
  • CREATE OR REPLACE LANGUAGE ... syntax added (commit 11b58470)
  • INLINE option added (commit 9048b731)
  • deprecated LANCOMPILER option removed (commit 9048b731)
• PostgreSQL 8.1
  • simplified CREATE LANGUAGE name syntax added, which uses information stored in pg_pltemplate to create the language (commits e0dedd05 and 48123de7)
• PostgreSQL 7.3
  • VALIDATOR option added (commit d60f10b0)
  • PROCEDURAL keyword now optional (commit 4b71943b)
• PostgreSQL 7.2
  • LANCOMPILER option deprecated (commit ee8ed85d)
• PostgreSQL 6.3
  • added as CREATE PROCEDURAL LANGUAGE (commit 7bff4c50)

References

Categories

See also