select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

The catalog pg_pltemplate stores “template” information for procedural languages.

Historical documentation for a PostgreSQL version that is no longer supported.

Kind
System catalogs
Columns in this snapshot
8
Definition source
English manual

Columns 8

ColumnTypeDescription / reference
tmplnamenameName of the language this template is for
tmpltrustedbooleanTrue if language is considered trusted
tmpldbacreatebooleanTrue if language may be created by a database owner
tmplhandlertextName of call handler function
tmplinlinetextName of anonymous-block handler function, or null if none
tmplvalidatortextName of validator function, or null if none
tmpllibrarytextPath of shared library that implements language
tmplaclaclitem[]Access privileges for template (not actually used)
Column history across versions
Version history 3
  1. PG 12 → 13removed
  2. PG 9.6 → 10changed
  3. PG 9.0 → 9.1changed

Definition snapshot: english-manuals:19b0ff3af16ef5710ccd33e39d5… · English manual source