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 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.
- PostgreSQL 8.3
- added (commit 140d4ebc)
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)
References
- PostgreSQL documentation: pg_ts_dict