pg_ts_config_map — PostgreSQL system catalog

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

Summary

The pg_ts_config_map catalog contains entries showing which text search dictionaries should be consulted, and in what order, for each output token type of each text search configuration’s parser.

(Description quoted from the official PostgreSQL documentation.)

Columns

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

  • mapcfg oid references pg_ts_config.oid
    The OID of the pg_ts_config entry owning this map entry
  • maptokentype int4
    A token type emitted by the configuration’s parser
  • mapseqno int4
    Order in which to consult this entry (lower mapseqnos first)
  • mapdict oid references pg_ts_dict.oid
    The OID of the text search dictionary to consult

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_config_map.