pg_pltemplate

A system catalogue table storing implementation detail for procedural languages

pg_pltemplate is a system catalogue table storing implementation detail for procedural languages.

pg_pltemplate was introduced in PostgreSQL 8.1 (commit 48123de7) and removed in PostgreSQL 13 (commit 50fc694e).

This table is shared across all databases in a cluster.

Definition by PostgreSQL version

pg_pltemplate (PostgreSQL 12)

              Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Collation | Nullable | Default
---------------+-----------+-----------+----------+---------
 tmplname      | name      |           | not null |
 tmpltrusted   | boolean   |           | not null |
 tmpldbacreate | boolean   |           | not null |
 tmplhandler   | text      | C         | not null |
 tmplinline    | text      | C         |          |
 tmplvalidator | text      | C         |          |
 tmpllibrary   | text      | C         | not null |
 tmplacl       | aclitem[] |           |          |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 11)

              Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Collation | Nullable | Default
---------------+-----------+-----------+----------+---------
 tmplname      | name      |           | not null |
 tmpltrusted   | boolean   |           | not null |
 tmpldbacreate | boolean   |           | not null |
 tmplhandler   | text      |           | not null |
 tmplinline    | text      |           |          |
 tmplvalidator | text      |           |          |
 tmpllibrary   | text      |           | not null |
 tmplacl       | aclitem[] |           |          |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 10)

              Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Collation | Nullable | Default
---------------+-----------+-----------+----------+---------
 tmplname      | name      |           | not null |
 tmpltrusted   | boolean   |           | not null |
 tmpldbacreate | boolean   |           | not null |
 tmplhandler   | text      |           | not null |
 tmplinline    | text      |           |          |
 tmplvalidator | text      |           |          |
 tmpllibrary   | text      |           | not null |
 tmplacl       | aclitem[] |           |          |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 9.6)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      | not null
 tmplinline    | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      | not null
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 9.5)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      | not null
 tmplinline    | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      | not null
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 9.4)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      |
 tmplinline    | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      |
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 9.3)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      |
 tmplinline    | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      |
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 9.2)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      |
 tmplinline    | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      |
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 9.1)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      |
 tmplinline    | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      |
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 9.0)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      |
 tmplinline    | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      |
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 8.4)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      |
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 8.3)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmpldbacreate | boolean   | not null
 tmplhandler   | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      |
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

pg_pltemplate (PostgreSQL 8.2)

   Table "pg_catalog.pg_pltemplate"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 tmplname      | name      | not null
 tmpltrusted   | boolean   | not null
 tmplhandler   | text      |
 tmplvalidator | text      |
 tmpllibrary   | text      |
 tmplacl       | aclitem[] |
Indexes:
    "pg_pltemplate_name_index" UNIQUE, btree (tmplname), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_pltemplate

Change history

PostgreSQL 13
- removed following the introduction of the concept of "trusted extensions" (commit 50fc694e, pgsql-hackers thread: "Removing pg_pltemplate and creating "trustable" extensions")
PostgreSQL 9.0
- column tmplinline added (commit 9048b731)
PostgreSQL 8.3
- column tmpldbacreate added (commit 55a7cf80)
PostgreSQL 8.1
- added (commit 48123de7)

Examples

postgres=# SELECT * FROM pg_pltemplate WHERE tmplname='plpgsql';
-[ RECORD 1 ]-+-----------------------
tmplname      | plpgsql
tmpltrusted   | t
tmpldbacreate | t
tmplhandler   | plpgsql_call_handler
tmplinline    | plpgsql_inline_handler
tmplvalidator | plpgsql_validator
tmpllibrary   | $libdir/plpgsql
tmplacl       |

References

PostgreSQL documentation: pg_pltemplate

Useful articles

Useful links

Contents

pg_pltemplate

Definition by PostgreSQL version

pg_pltemplate (PostgreSQL 12)

pg_pltemplate (PostgreSQL 11)

pg_pltemplate (PostgreSQL 10)

pg_pltemplate (PostgreSQL 9.6)

pg_pltemplate (PostgreSQL 9.5)

pg_pltemplate (PostgreSQL 9.4)

pg_pltemplate (PostgreSQL 9.3)

pg_pltemplate (PostgreSQL 9.2)

pg_pltemplate (PostgreSQL 9.1)

pg_pltemplate (PostgreSQL 9.0)

pg_pltemplate (PostgreSQL 8.4)

pg_pltemplate (PostgreSQL 8.3)

pg_pltemplate (PostgreSQL 8.2)

Change history

Examples

References

Categories