Contents

pg_ts_dict

A system table defining full text search dictionaries

pg_ts_dict is a system catalogue table defining full text search dictionaries.

pg_ts_dict was added in PostgreSQL 8.3.

Definition by PostgreSQL version

pg_ts_dict (PostgreSQL 14)

             Table "pg_catalog.pg_ts_dict"
     Column     | Type | Collation | Nullable | Default 
----------------+------+-----------+----------+---------
 oid            | oid  |           | not null | 
 dictname       | name |           | not null | 
 dictnamespace  | oid  |           | not null | 
 dictowner      | oid  |           | not null | 
 dicttemplate   | oid  |           | not null | 
 dictinitoption | text | C         |          | 
Indexes:
    "pg_ts_dict_oid_index" PRIMARY KEY, btree (oid)
    "pg_ts_dict_dictname_index" UNIQUE CONSTRAINT, btree (dictname, dictnamespace)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 13)

             Table "pg_catalog.pg_ts_dict"
     Column     | Type | Collation | Nullable | Default 
----------------+------+-----------+----------+---------
 oid            | oid  |           | not null | 
 dictname       | name |           | not null | 
 dictnamespace  | oid  |           | not null | 
 dictowner      | oid  |           | not null | 
 dicttemplate   | oid  |           | not null | 
 dictinitoption | text | C         |          | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 12)

             Table "pg_catalog.pg_ts_dict"
     Column     | Type | Collation | Nullable | Default 
----------------+------+-----------+----------+---------
 oid            | oid  |           | not null | 
 dictname       | name |           | not null | 
 dictnamespace  | oid  |           | not null | 
 dictowner      | oid  |           | not null | 
 dicttemplate   | oid  |           | not null | 
 dictinitoption | text | C         |          | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 11)

             Table "pg_catalog.pg_ts_dict"
     Column     | Type | Collation | Nullable | Default 
----------------+------+-----------+----------+---------
 dictname       | name |           | not null | 
 dictnamespace  | oid  |           | not null | 
 dictowner      | oid  |           | not null | 
 dicttemplate   | oid  |           | not null | 
 dictinitoption | text |           |          | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 10)

             Table "pg_catalog.pg_ts_dict"
     Column     | Type | Collation | Nullable | Default 
----------------+------+-----------+----------+---------
 dictname       | name |           | not null | 
 dictnamespace  | oid  |           | not null | 
 dictowner      | oid  |           | not null | 
 dicttemplate   | oid  |           | not null | 
 dictinitoption | text |           |          | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 9.6)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 9.5)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 9.4)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 9.3)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 9.2)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 9.1)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 9.0)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 8.4)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

pg_ts_dict (PostgreSQL 8.3)

   Table "pg_catalog.pg_ts_dict"
     Column     | Type | Modifiers 
----------------+------+-----------
 dictname       | name | not null
 dictnamespace  | oid  | not null
 dictowner      | oid  | not null
 dicttemplate   | oid  | not null
 dictinitoption | text | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

Documentation: pg_ts_dict

Change history

This table has not been modified since it was added in PostgreSQL 8.3.

Examples

postgres=# \d pg_ts_dict
             Table "pg_catalog.pg_ts_dict"
     Column     | Type | Collation | Nullable | Default 
----------------+------+-----------+----------+---------
 oid            | oid  |           | not null | 
 dictname       | name |           | not null | 
 dictnamespace  | oid  |           | not null | 
 dictowner      | oid  |           | not null | 
 dicttemplate   | oid  |           | not null | 
 dictinitoption | text | C         |          | 
Indexes:
    "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace)
    "pg_ts_dict_oid_index" UNIQUE, btree (oid)

postgres=# SELECT * FROM pg_ts_dict;
  oid  |    dictname     | dictnamespace | dictowner | dicttemplate |                  dictinitoption                   
-------+-----------------+---------------+-----------+--------------+---------------------------------------------------
  3765 | simple          |            11 |        10 |         3727 | 
 13251 | arabic_stem     |            11 |        10 |        13250 | language = 'arabic'
 13253 | danish_stem     |            11 |        10 |        13250 | language = 'danish', stopwords = 'danish'
 13255 | dutch_stem      |            11 |        10 |        13250 | language = 'dutch', stopwords = 'dutch'
 13257 | english_stem    |            11 |        10 |        13250 | language = 'english', stopwords = 'english'
 13259 | finnish_stem    |            11 |        10 |        13250 | language = 'finnish', stopwords = 'finnish'
 13261 | french_stem     |            11 |        10 |        13250 | language = 'french', stopwords = 'french'
 13263 | german_stem     |            11 |        10 |        13250 | language = 'german', stopwords = 'german'
 13265 | greek_stem      |            11 |        10 |        13250 | language = 'greek'
 13267 | hungarian_stem  |            11 |        10 |        13250 | language = 'hungarian', stopwords = 'hungarian'
 13269 | indonesian_stem |            11 |        10 |        13250 | language = 'indonesian'
 13271 | irish_stem      |            11 |        10 |        13250 | language = 'irish'
 13273 | italian_stem    |            11 |        10 |        13250 | language = 'italian', stopwords = 'italian'
 13275 | lithuanian_stem |            11 |        10 |        13250 | language = 'lithuanian'
 13277 | nepali_stem     |            11 |        10 |        13250 | language = 'nepali', stopwords = 'nepali'
 13279 | norwegian_stem  |            11 |        10 |        13250 | language = 'norwegian', stopwords = 'norwegian'
 13281 | portuguese_stem |            11 |        10 |        13250 | language = 'portuguese', stopwords = 'portuguese'
 13283 | romanian_stem   |            11 |        10 |        13250 | language = 'romanian'
 13285 | russian_stem    |            11 |        10 |        13250 | language = 'russian', stopwords = 'russian'
 13287 | spanish_stem    |            11 |        10 |        13250 | language = 'spanish', stopwords = 'spanish'
 13289 | swedish_stem    |            11 |        10 |        13250 | language = 'swedish', stopwords = 'swedish'
 13291 | tamil_stem      |            11 |        10 |        13250 | language = 'tamil'
 13293 | turkish_stem    |            11 |        10 |        13250 | language = 'turkish', stopwords = 'turkish'
(23 rows)

Categories

Full Text Search, System catalogue

See also

pg_ts_dict_is_visible(), pg_ts_config, pg_ts_config_map, pg_ts_parser, pg_ts_template