目录

pg_ts_config_map

一个确定分词器词语类型对应的全文检索字典咨询顺序的系统表

pg_ts_config_map 是一个 系统目录 表，它确定分词器词语类型对应的全文检索字典的咨询顺序。

pg_ts_config_map 在 PostgreSQL 8.3 中被添加。

按 PostgreSQL 版本定义

pg_ts_config_map (PostgreSQL 19)

           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)

文档: pg_ts_config_map

pg_ts_config_map (PostgreSQL 18)

           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)

文档: pg_ts_config_map

pg_ts_config_map (PostgreSQL 17)

           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)

文档: pg_ts_config_map

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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: pg_ts_config_map

变更历史

自 PostgreSQL 8.3 添加以来，此表未被修改。

示例

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)

分类

全文搜索, 系统目录

另请参阅

pg_ts_config, pg_ts_dict, pg_ts_parser, pg_ts_template

反馈

请在此处 提交有关“pg_ts_config_map”的任何评论、建议或更正。