#openGauss #入门 #安装 #数据库 #开源

知识来源：docs-opengauss.osinfra.cn/zh/

Synonym词典

Synonym词典用于定义、识别token的同义词并转化，不支持词组（词组形式的同义词可用Thesaurus词典定义，详细请参见Thesaurus词典）。

示例

• Synonym词典可用于解决语言学相关问题，例如，为避免使单词“Paris”变成“pari”，可在Synonym词典文件中定义一行“Paris paris”，并将该词典放置在预定义的english_stem词典之前。

  openGauss=# SELECT * FROM ts_debug('english', 'Paris');
     alias   |   Description   | token |  dictionaries  |  dictionary  | lexemes 
  -----------+-----------------+-------+----------------+--------------+---------
   asciiword | Word, all ASCII | Paris | {english_stem} | english_stem | {pari}
  (1 row)
  
  openGauss=# CREATE TEXT SEARCH DICTIONARY my_synonym (
      TEMPLATE = synonym,
      SYNONYMS = my_synonyms,
      FILEPATH = 'file:///home/dicts/' 
  );
  
  openGauss=# ALTER TEXT SEARCH CONFIGURATION english
      ALTER MAPPING FOR asciiword
      WITH my_synonym, english_stem;
  
  openGauss=# SELECT * FROM ts_debug('english', 'Paris');
     alias   |   Description   | token |       dictionaries        | dictionary | lexemes 
  -----------+-----------------+-------+---------------------------+------------+---------
   asciiword | Word, all ASCII | Paris | {my_synonym,english_stem} | my_synonym | {paris}
  (1 row)
  
  openGauss=# SELECT * FROM ts_debug('english', 'paris');
     alias   |   Description   | token |       dictionaries        | dictionary | lexemes 
  -----------+-----------------+-------+---------------------------+------------+---------
   asciiword | Word, all ASCII | Paris | {my_synonym,english_stem} | my_synonym | {paris}
  (1 row)
  
  openGauss=# ALTER TEXT SEARCH DICTIONARY my_synonym ( CASESENSITIVE=true);
  
  openGauss=# SELECT * FROM ts_debug('english', 'Paris');
     alias   |   Description   | token |       dictionaries        | dictionary | lexemes 
  -----------+-----------------+-------+---------------------------+------------+---------
   asciiword | Word, all ASCII | Paris | {my_synonym,english_stem} | my_synonym | {paris}
  (1 row)
  
  openGauss=# SELECT * FROM ts_debug('english', 'paris');
     alias   |   Description   | token |       dictionaries        | dictionary | lexemes 
  -----------+-----------------+-------+---------------------------+------------+---------
   asciiword | Word, all ASCII | Paris | {my_synonym,english_stem} | my_synonym | {pari}
  (1 row)
  

  其中，同义词词典文件全名为my_synonyms.syn，所在目录为当前连接数据库主节点的/home/dicts/下。关于创建词典的语法和更多参数，请参见ALTER TEXT SEARCH DICTIONARY。

#openGauss #入门 #安装 #数据库 #开源

知识来源：docs-opengauss.osinfra.cn/zh/