↑↓ select ↵ open ⌫ change scope Open full search

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

System Catalogs / System catalogs

pg_pltemplate

Read the PG 12 manual

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

Reading PG 12·documented in 14 of 24 versions, 8.1 to 12

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

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

Columns 8

As listed in the PostgreSQL 12 manual.

ColumnTypeDescription / reference
tmplnamenameNOT NULLName of the language this template is for
tmpltrustedbooleanNOT NULLTrue if language is considered trusted
tmpldbacreatebooleanNOT NULLTrue if language may be created by a database owner
tmplhandlertextNOT NULLName of call handler function
tmplinlinetextName of anonymous-block handler function, or null if none
tmplvalidatortextName of validator function, or null if none
tmpllibrarytextNOT NULLPath of shared library that implements language
tmplaclaclitem[]Access privileges for template (not actually used)
Column history across versions
Version history 7
  1. 12 → 13 removed
  2. 9.6 → 10 reworded
  3. 9.4 → 9.5 changed
  4. 9.0 → 9.1 reworded
  5. 8.4 → 9.0 changed
  6. 8.2 → 8.3 changed
  7. 8.0 → 8.1 added

Definition snapshot: english-manuals:d7c8aeb42da131ff2fb13364ffe… · English manual source