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.
Table 44-39. pg_ts_dict Columns
Name | Type | References | Description |
---|
dictname | name | | Text search dictionary name |
dictnamespace | oid | pg_namespace.oid | The OID of the namespace that contains this dictionary
|
dictowner | oid | pg_authid.oid | Owner of the dictionary |
dicttemplate | oid | pg_ts_template.oid | The OID of the text search template for this dictionary |
dictinitoption | text | | Initialization option string for the template |