PG_TS_DICT

Updated on 2023-10-31 GMT+08:00

View PDF

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	-	Row identifier (hidden attribute; must be explicitly selected)
dictname	name	-	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	-	Initialization option string for the template