Contents

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.

Examples

postgres=# \d pg_ts_template
            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)

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)

Categories

Full Text Search, System catalogue

See also

pg_ts_template_is_visible(), pg_ts_config, pg_ts_config_map, pg_ts_dict, pg_ts_parser