PostgreSQL 9.3.6 Documentation
Prev | Up | Chapter 47. System Catalogs | Next

# 47.48. `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 47-48. `pg_ts_dict` Columns

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

Prev | Home | Next
`pg_ts_config_map` | Up | `pg_ts_parser`