Updated on 2025-07-22 GMT+08:00

PG_TS_DICT

PG_TS_DICT records entries that define 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.

Table 1 PG_TS_DICT columns

Name

Type

Reference

Description

OID

OID

N/A

Row identifier (hidden attribute; displayed only when explicitly selected)

dictname

Name

N/A

Text search dictionary name

dictnamespace

OID

PG_NAMESPACE.oid

OID of the namespace that contains the dictionary

dictowner

OID

PG_AUTHID.oid

Owner of the dictionary

dicttemplate

OID

PG_TS_TEMPLATE.oid

OID of the text search template for this dictionary

dictinitoption

Text

N/A

Initialization option string for the template