PostgreSQL

PostgreSQL Elephant Logo

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

Name Type References Description

oid

oid

Row identifier

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

51.59. pg_ts_config_map

Home

51.61. pg_ts_parser

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Copyright © 1996-2023 The PostgreSQL Global Development Group