内容

pg_ts_config_map

一个系统表，用于确定文本搜索词典对于解析器标记类型的查询顺序

pg_ts_config_map 是一个用于确定文本搜索词典对于解析器标记类型的查询顺序的系统目录表。

pg_ts_config_map 在PostgreSQL 8.3中添加。

按 PostgreSQL 版本定义

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" 的任何评论、建议或更正 此处。