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 49-51. pg_ts_dict Columns

Name Type References Description
oid oid Row identifier (hidden attribute; must be explicitly selected)
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