↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / System Catalogs

pg_ts_template

The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search dictionaries. Since a template must be implemented by C-language-level functions, creation of new templates is restricted to database superusers. PostgreSQL's text search features are described at length in Chapter 12.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

kind
catalog
lang
en
measured attributes
true
metadata release
18.6
runtime columns
oid, tmplname, tmplnamespace, tmplinit, tmpllexize
runtime verified
false
source
english-manual

Definition PG 18

The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search dictionaries. Since a template must be implemented by C-language-level functions, creation of new templates is restricted to database superusers. PostgreSQL's text search features are described at length in Chapter 12.

Catalog columns

ColumnTypeNullabilityDescription
oidoidNot nullRow identifier
tmplnamenameNot nullText search template name
tmplnamespaceoidNot nullThe OID of the namespace that contains this template
tmplinitregprocNot nullOID of the template's initialization function (zero if none)
tmpllexizeregprocNot nullOID of the template's lexize function

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:384b93864b440813ba4acbe19bd565079021e621e9fdbe020c3d4660c75f5cfd

Text language: en · catalog-bilingual-repair:384b93864b440813ba4acbe19bd565079021e621e9fdbe020c3d4660c75f5cfd