Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_TS_DICT

PG_TS_DICT

Updated at: Jul 15, 2020 GMT+08:00

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

-

Column identifier (hidden attribute; must be explicitly selected)

dictname

name

-

Text search dictionary name

dictnamespace

oid

PG_NAMESPACE.oid

OID of the namespace that contains this 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

-

Initialization option string for the template

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel