Contents
pg_pltemplate
pg_pltemplate
is a system catalogue table storing implementation details for procedural languages.
pg_pltemplate
was added in PostgreSQL 8.1 and removed in PostgreSQL 13.
This table is shared across all databases in a cluster.
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.5
- columns
tmplhandler
andtmpllibrary
set toNOT NULL
(commit 82a532b3) -
- columns
- PostgreSQL 9.0
- column
tmplinline
added (commit 9048b731)
- column
- PostgreSQL 8.3
- column
tmpldbacreate
added (commit 55a7cf80)
- column
- 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 12 documentation: pg_pltemplate