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 16)
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 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.
- PostgreSQL 8.3
- added (commit 140d4ebc)
Examples
Sample contents of pg_ts_config_map:
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)
References
- PostgreSQL documentation: pg_ts_config_map