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 16)

             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 15)

             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 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

Typical contents of pg_ts_dict:

postgres=# SELECT * FROM pg_ts_dict;
  oid  |    dictname     | dictnamespace | dictowner | dicttemplate |                  dictinitoption
-------+-----------------+---------------+-----------+--------------+---------------------------------------------------
  3765 | simple          |            11 |        10 |         3727 |
 13551 | arabic_stem     |            11 |        10 |        13550 | language = 'arabic'
 13553 | armenian_stem   |            11 |        10 |        13550 | language = 'armenian'
 13555 | basque_stem     |            11 |        10 |        13550 | language = 'basque'
 13557 | catalan_stem    |            11 |        10 |        13550 | language = 'catalan'
 13559 | danish_stem     |            11 |        10 |        13550 | language = 'danish', stopwords = 'danish'
 13561 | dutch_stem      |            11 |        10 |        13550 | language = 'dutch', stopwords = 'dutch'
 13563 | english_stem    |            11 |        10 |        13550 | language = 'english', stopwords = 'english'
 13565 | finnish_stem    |            11 |        10 |        13550 | language = 'finnish', stopwords = 'finnish'
 13567 | french_stem     |            11 |        10 |        13550 | language = 'french', stopwords = 'french'
 13569 | german_stem     |            11 |        10 |        13550 | language = 'german', stopwords = 'german'
 13571 | greek_stem      |            11 |        10 |        13550 | language = 'greek'
 13573 | hindi_stem      |            11 |        10 |        13550 | language = 'hindi'
 13575 | hungarian_stem  |            11 |        10 |        13550 | language = 'hungarian', stopwords = 'hungarian'
 13577 | indonesian_stem |            11 |        10 |        13550 | language = 'indonesian'
 13579 | irish_stem      |            11 |        10 |        13550 | language = 'irish'
 13581 | italian_stem    |            11 |        10 |        13550 | language = 'italian', stopwords = 'italian'
 13583 | lithuanian_stem |            11 |        10 |        13550 | language = 'lithuanian'
 13585 | nepali_stem     |            11 |        10 |        13550 | language = 'nepali', stopwords = 'nepali'
 13587 | norwegian_stem  |            11 |        10 |        13550 | language = 'norwegian', stopwords = 'norwegian'
 13589 | portuguese_stem |            11 |        10 |        13550 | language = 'portuguese', stopwords = 'portuguese'
 13591 | romanian_stem   |            11 |        10 |        13550 | language = 'romanian'
 13593 | russian_stem    |            11 |        10 |        13550 | language = 'russian', stopwords = 'russian'
 13595 | serbian_stem    |            11 |        10 |        13550 | language = 'serbian'
 13597 | spanish_stem    |            11 |        10 |        13550 | language = 'spanish', stopwords = 'spanish'
 13599 | swedish_stem    |            11 |        10 |        13550 | language = 'swedish', stopwords = 'swedish'
 13601 | tamil_stem      |            11 |        10 |        13550 | language = 'tamil'
 13603 | turkish_stem    |            11 |        10 |        13550 | language = 'turkish', stopwords = 'turkish'
 13605 | yiddish_stem    |            11 |        10 |        13550 | language = 'yiddish'
(29 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