18th October 2018: PostgreSQL 11 Released!
Supported Versions: Current (11) / 10 / 9.6 / 9.5 / 9.4 / 9.3
Development Versions: devel
Unsupported versions: 9.2 / 9.1 / 9.0 / 8.4 / 8.3

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

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