↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / 20devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3
Historical version. PostgreSQL 11 has reached end of support. 2023-11-09. See the current manual.

52.59. 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 52.59. pg_ts_dict Columns

NameTypeReferencesDescription
oidoid Row identifier (hidden attribute; must be explicitly selected)
dictnamename Text search dictionary name
dictnamespaceoidpg_namespace.oid The OID of the namespace that contains this dictionary
dictowneroidpg_authid.oidOwner of the dictionary
dicttemplateoidpg_ts_template.oidThe OID of the text search template for this dictionary
dictinitoptiontext Initialization option string for the template

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.