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