pg_pltemplate

The pg_pltemplate system catalog table stores template information for procedural languages. A template for a language allows the language to be created in a particular database by a CREATE LANGUAGE command, with no need to specify implementation details.

Unlike most system catalogs, pg_pltemplate is shared across all databases of the Greengage DB system: there is only one copy of pg_pltemplate per system, not one per database. This allows the information to be accessible in each database as it is necessary.

Column Type Description

Column	Type	Description
tmplname	name	Name of the language this template is for
tmpltrusted	boolean	`true` if language is considered trusted
tmpldbacreate	boolean	`true` if language may be created by a database owner
tmplhandler	text	Name of call handler function
tmplinline	text	Name of anonymous-block handler function, or `NULL` if none
tmplvalidator	text	Name of validator function, or `NULL` if none
tmpllibrary	text	Path of a shared library that implements language
tmplacl	aclitem[]	Access privileges for the template (not yet implemented)

tmplname

name

Name of the language this template is for

tmpltrusted

boolean

true if language is considered trusted

tmpldbacreate

boolean

true if language may be created by a database owner

tmplhandler

text

Name of call handler function

tmplinline

text

Name of anonymous-block handler function, or NULL if none

tmplvalidator

text

Name of validator function, or NULL if none

tmpllibrary

text

Path of a shared library that implements language

tmplacl

aclitem[]

Access privileges for the template (not yet implemented)

pg_partition_rule

pg_proc