Updated on 2025-07-22 GMT+08:00

PG_PLTEMPLATE

PG_PLTEMPLATE records template information for procedural languages.

Table 1 PG_PLTEMPLATE columns

Column

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.

tmpldbacreate

boolean

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

tmplhandler

Text

Name of the call handler function.

tmplinline

Text

Name of the anonymous block handler. If no name of the block handler exists, the value is null.

tmplvalidator

Text

Name of the verification function. If no verification function is available, the value is null.

tmpllibrary

Text

Path of the shared library that implements languages.

tmplacl

aclitem[]

Access permissions for template (not yet used).