pg_ts_dict — PostgreSQL system catalog

The PostgreSQL pg_ts_dict system catalog: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  2 min read

Summary

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.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_ts_dict system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • oid oid
    Row identifier
  • dictname name
    Text search dictionary name
  • dictnamespace oid references pg_namespace.oid
    The OID of the namespace that contains this dictionary
  • dictowner oid references pg_authid.oid
    Owner of the dictionary
  • dicttemplate oid references pg_ts_template.oid
    The OID of the text search template for this dictionary
  • dictinitoption text
    Initialization option string for the template

Related catalogs

This object references the following other system catalogs:

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_ts_dict.