Contents

pg_ts_config_map

A system table determining consultation order of text search dictionaries for parser token types

pg_ts_config_map is a system catalogue table determining consultation order of text search dictionaries for parser token types.

pg_ts_config_map was added in PostgreSQL 8.3.

Definition by PostgreSQL version

pg_ts_config_map (PostgreSQL 15)

           Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 mapcfg       | oid     |           | not null | 
 maptokentype | integer |           | not null | 
 mapseqno     | integer |           | not null | 
 mapdict      | oid     |           | not null | 
Indexes:
    "pg_ts_config_map_index" PRIMARY KEY, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 14)

           Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 mapcfg       | oid     |           | not null | 
 maptokentype | integer |           | not null | 
 mapseqno     | integer |           | not null | 
 mapdict      | oid     |           | not null | 
Indexes:
    "pg_ts_config_map_index" PRIMARY KEY, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 13)

           Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 mapcfg       | oid     |           | not null | 
 maptokentype | integer |           | not null | 
 mapseqno     | integer |           | not null | 
 mapdict      | oid     |           | not null | 
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 12)

           Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 mapcfg       | oid     |           | not null | 
 maptokentype | integer |           | not null | 
 mapseqno     | integer |           | not null | 
 mapdict      | oid     |           | not null | 
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 11)

           Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 mapcfg       | oid     |           | not null | 
 maptokentype | integer |           | not null | 
 mapseqno     | integer |           | not null | 
 mapdict      | oid     |           | not null | 
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 10)

           Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 mapcfg       | oid     |           | not null | 
 maptokentype | integer |           | not null | 
 mapseqno     | integer |           | not null | 
 mapdict      | oid     |           | not null | 
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 9.6)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 9.5)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 9.4)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 9.3)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 9.2)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 9.1)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 9.0)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 8.4)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

pg_ts_config_map (PostgreSQL 8.3)

Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 mapcfg       | oid     | not null
 maptokentype | integer | not null
 mapseqno     | integer | not null
 mapdict      | oid     | not null
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

Documentation: pg_ts_config_map

Change history

This table has not been modified since it was added in PostgreSQL 8.3.

Examples

postgres=# \d pg_ts_config_map
           Table "pg_catalog.pg_ts_config_map"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 mapcfg       | oid     |           | not null | 
 maptokentype | integer |           | not null | 
 mapseqno     | integer |           | not null | 
 mapdict      | oid     |           | not null | 
Indexes:
    "pg_ts_config_map_index" UNIQUE, btree (mapcfg, maptokentype, mapseqno)

postgres=# SELECT * FROM pg_ts_config_map WHERE mapcfg IN (SELECT oid FROM pg_ts_config WHERE cfgname = 'simple');
 mapcfg | maptokentype | mapseqno | mapdict 
--------+--------------+----------+---------
   3748 |            1 |        1 |    3765
   3748 |            2 |        1 |    3765
   3748 |            3 |        1 |    3765
   3748 |            4 |        1 |    3765
   3748 |            5 |        1 |    3765
   3748 |            6 |        1 |    3765
   3748 |            7 |        1 |    3765
   3748 |            8 |        1 |    3765
   3748 |            9 |        1 |    3765
   3748 |           10 |        1 |    3765
   3748 |           11 |        1 |    3765
   3748 |           15 |        1 |    3765
   3748 |           16 |        1 |    3765
   3748 |           17 |        1 |    3765
   3748 |           18 |        1 |    3765
   3748 |           19 |        1 |    3765
   3748 |           20 |        1 |    3765
   3748 |           21 |        1 |    3765
   3748 |           22 |        1 |    3765
(19 rows)

Categories

Full Text Search, System catalogue

See also

pg_ts_config, pg_ts_dict, pg_ts_parser, pg_ts_template