pg_ts_template
A system table defining full text search templates
pg_ts_template
is a system catalogue table defining full text search templates.
pg_ts_template
was added in PostgreSQL 8.3.
Definition by PostgreSQL version
pg_ts_template (PostgreSQL 15)
Table "pg_catalog.pg_ts_template" Column | Type | Collation | Nullable | Default ---------------+---------+-----------+----------+--------- oid | oid | | not null | tmplname | name | | not null | tmplnamespace | oid | | not null | tmplinit | regproc | | not null | tmpllexize | regproc | | not null | Indexes: "pg_ts_template_oid_index" PRIMARY KEY, btree (oid) "pg_ts_template_tmplname_index" UNIQUE CONSTRAINT, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 14)
Table "pg_catalog.pg_ts_template" Column | Type | Collation | Nullable | Default ---------------+---------+-----------+----------+--------- oid | oid | | not null | tmplname | name | | not null | tmplnamespace | oid | | not null | tmplinit | regproc | | not null | tmpllexize | regproc | | not null | Indexes: "pg_ts_template_oid_index" PRIMARY KEY, btree (oid) "pg_ts_template_tmplname_index" UNIQUE CONSTRAINT, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 13)
Table "pg_catalog.pg_ts_template" Column | Type | Collation | Nullable | Default ---------------+---------+-----------+----------+--------- oid | oid | | not null | tmplname | name | | not null | tmplnamespace | oid | | not null | tmplinit | regproc | | not null | tmpllexize | regproc | | not null | Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 12)
Table "pg_catalog.pg_ts_template" Column | Type | Collation | Nullable | Default ---------------+---------+-----------+----------+--------- oid | oid | | not null | tmplname | name | | not null | tmplnamespace | oid | | not null | tmplinit | regproc | | not null | tmpllexize | regproc | | not null | Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 11)
Table "pg_catalog.pg_ts_template" Column | Type | Collation | Nullable | Default ---------------+---------+-----------+----------+--------- tmplname | name | | not null | tmplnamespace | oid | | not null | tmplinit | regproc | | not null | tmpllexize | regproc | | not null | Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 10)
Table "pg_catalog.pg_ts_template" Column | Type | Collation | Nullable | Default ---------------+---------+-----------+----------+--------- tmplname | name | | not null | tmplnamespace | oid | | not null | tmplinit | regproc | | not null | tmpllexize | regproc | | not null | Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 9.6)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 9.5)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 9.4)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 9.3)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 9.2)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 9.1)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 9.0)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 8.4)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
pg_ts_template (PostgreSQL 8.3)
Table "pg_catalog.pg_ts_template" Column | Type | Modifiers ---------------+---------+----------- tmplname | name | not null tmplnamespace | oid | not null tmplinit | regproc | not null tmpllexize | regproc | not null Indexes: "pg_ts_template_oid_index" UNIQUE, btree (oid) "pg_ts_template_tmplname_index" UNIQUE, btree (tmplname, tmplnamespace)
Documentation: pg_ts_template
Change history
This table has not been modified since it was added in PostgreSQL 8.3.
- PostgreSQL 8.3
- added (commit 140d4ebc)
Examples
Typical contents of pg_ts_template
:
postgres=# SELECT * FROM pg_ts_template; oid | tmplname | tmplnamespace | tmplinit | tmpllexize -------+-----------+---------------+----------------+------------------ 3727 | simple | 11 | dsimple_init | dsimple_lexize 3730 | synonym | 11 | dsynonym_init | dsynonym_lexize 3733 | ispell | 11 | dispell_init | dispell_lexize 3742 | thesaurus | 11 | thesaurus_init | thesaurus_lexize 13250 | snowball | 11 | dsnowball_init | dsnowball_lexize (5 rows)
References
- PostgreSQL documentation: pg_ts_template