PostgreSQL

52.59. `pg_ts_dict`
Prev	Up	Chapter 52. System Catalogs	Home	Next

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

Name Type References Description

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

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

Prev	Up	Next
52.58. `pg_ts_config_map`	Home	52.60. `pg_ts_parser`

52.58. pg_ts_config_map

Home

52.60. pg_ts_parser

PostgreSQL

52.59. pg_ts_dict

52.59. `pg_ts_dict`