数据仓库服务 GAUSSDB(DWS)-ALTER TEXT SEARCH CONFIGURATION:示例

时间：2024-04-18 16:25:02

示例

给文本搜索类型ngram1添加类型映射：

  
       ALTER TEXT SEARCH CONFIGURATION ngram1 ADD MAPPING FOR multisymbol WITH simple;

修改文本搜索配置的所有者：

  
       ALTER TEXT SEARCH CONFIGURATION ngram1 OWNER TO joe;

修改文本搜索配置的schema：

  
       ALTER TEXT SEARCH CONFIGURATION ngram1 SET SCHEMA joe;

重命名文本搜索配置：

  
       ALTER TEXT SEARCH CONFIGURATION joe.ngram1 RENAME TO ngram_1;

删除类型映射：

  
       ALTER TEXT SEARCH CONFIGURATION joe.ngram_1 DROP MAPPING IF EXISTS FOR multisymbol;

增加文本搜索配置字串类型映射语法：

  
       ALTER TEXT SEARCH CONFIGURATION english_1 ADD MAPPING FOR word WITH simple,english_stem;

增加文本搜索配置字串类型映射语法：

  
       ALTER TEXT SEARCH CONFIGURATION english_1 ADD MAPPING FOR email WITH english_stem, french_stem;

修改文本搜索配置字串类型映射语法：

  
       ALTER TEXT SEARCH CONFIGURATION english_1 ALTER MAPPING REPLACE french_stem with german_stem;

查询文本搜索配置相关信息：

  
       SELECT b.cfgname,a.maptokentype,a.mapseqno,a.mapdict,c.dictname FROM pg_ts_config_map a,pg_ts_config b, pg_ts_dict c WHERE a.mapcfg=b.oid AND a.mapdict=c.oid AND b.cfgname='english_1' ORDER BY 1,2,3,4,5;
  cfgname  | maptokentype | mapseqno | mapdict |   dictname   
-----------+--------------+----------+---------+--------------
 english_1 |            2 |        1 |    3765 | simple
 english_1 |            2 |        2 |   12960 | english_stem
 english_1 |            4 |        1 |   12960 | english_stem
 english_1 |            4 |        2 |   12966 | german_stem
(4 rows)