pg_ts_dict
The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all the implementation functions needed; the dictionary itself provides values for the user-settable parameters supported by the template. This division of labor allows dictionaries to be created by unprivileged users. The parameters are specified by a text string dictinitoption, whose format and meaning vary depending on the template. 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, dictname, dictnamespace, dictowner, dicttemplate, dictinitoption
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all the implementation functions needed; the dictionary itself provides values for the user-settable parameters supported by the template. This division of labor allows dictionaries to be created by unprivileged users. The parameters are specified by a text string dictinitoption, whose format and meaning vary depending on the template. PostgreSQL's text search features are described at length in Chapter 12.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| dictname | name | Not null | Text search dictionary name |
| dictnamespace | oid | Not null | The OID of the namespace that contains this dictionary |
| dictowner | oid | Not null | Owner of the dictionary |
| dicttemplate | oid | Not null | The OID of the text search template for this dictionary |
| dictinitoption | text | Nullable | Initialization option string for the template |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:1461ac80a2fd327f126af949952c99a5935cef7a52190f13eea43938cc25f4df
Text language: en · catalog-bilingual-repair:1461ac80a2fd327f126af949952c99a5935cef7a52190f13eea43938cc25f4df