Updated on 2023-10-23 GMT+08:00

PG_PLTEMPLATE

PG_PLTEMPLATE records template information for procedural languages.

Table 1 PG_PLTEMPLATE columns

Name

Type

Description

tmplname

name

Name of the language for which this template is used

tmpltrusted

boolean

The value is true if the language is considered trusted. Otherwise, the value is false.

tmpldbacreate

boolean

The value is true if the language is created by the owner of the database. Otherwise, the value is false.

tmplhandler

text

Name of the call handler function

tmplinline

text

Name of the anonymous block handler (NULL if no name of the block handler exists)

tmplvalidator

text

Name of the verification function (NULL if no verification function is available)

tmpllibrary

text

Path of the shared library that implements languages

tmplacl

aclitem[]

Access permissions for template (not yet used)