9.3 9.4 9.5 9.6 10 11 12 13 14 15
阿里云PostgreSQL 问题报告 纠错本页面

12.10. psql支持

关于文本搜索配置对象的信息可以在psql中使用一组命令获得:

\dF{d,p,t}[+] [PATTERN]

可选的+能产生更多细节。

可选参数PATTERN可以是一个文本搜索对象的名称,可以是模式限定的。如果PATTERN被忽略,则所有可见对象的信息都将被显示。PATTERN可以是一个正则表达式并且可以为模式和对象名称提供独立的模式。下面的例子展示了这些特性:

=> \dF *fulltext*
       List of text search configurations
 Schema |  Name        | Description
--------+--------------+-------------
 public | fulltext_cfg |

=> \dF *.fulltext*
       List of text search configurations
 Schema   |  Name        | Description
----------+----------------------------
 fulltext | fulltext_cfg |
 public   | fulltext_cfg |

可用的命令是:

\dF[+] [PATTERN]

列出文本搜索配置(添加+以获取更多详细信息)。

=> \dF russian
            文本搜索配置列表
   模式   |  名称   |            描述
------------+---------+------------------------------------
 pg_catalog | russian | 俄语语言的配置

=> \dF+ russian
文本搜索配置 "pg_catalog.russian"
解析器: "pg_catalog.default"
      标记      | 词典
-----------------+--------------
 asciihword      | english_stem
 asciiword       | english_stem
 email           | simple
 file            | simple
 float           | simple
 host            | simple
 hword           | russian_stem
 hword_asciipart | english_stem
 hword_numpart   | simple
 hword_part      | russian_stem
 int             | simple
 numhword        | simple
 numword         | simple
 sfloat          | simple
 uint            | simple
 url             | simple
 url_path        | simple
 version         | simple
 word            | russian_stem

\dFd[+] [PATTERN]

列出文本搜索词典(加上+得到更多细节)。

=> \dFd
                             List of text search dictionaries
   Schema   |      Name       |                        Description
------------+-----------------+-----------------------------------------------------------
 pg_catalog | arabic_stem     | snowball stemmer for arabic language
 pg_catalog | armenian_stem   | snowball stemmer for armenian language
 pg_catalog | basque_stem     | snowball stemmer for basque language
 pg_catalog | catalan_stem    | snowball stemmer for catalan language
 pg_catalog | danish_stem     | snowball stemmer for danish language
 pg_catalog | dutch_stem      | snowball stemmer for dutch language
 pg_catalog | english_stem    | snowball stemmer for english language
 pg_catalog | finnish_stem    | snowball stemmer for finnish language
 pg_catalog | french_stem     | snowball stemmer for french language
 pg_catalog | german_stem     | snowball stemmer for german language
 pg_catalog | greek_stem      | snowball stemmer for greek language
 pg_catalog | hindi_stem      | snowball stemmer for hindi language
 pg_catalog | hungarian_stem  | snowball stemmer for hungarian language
 pg_catalog | indonesian_stem | snowball stemmer for indonesian language
 pg_catalog | irish_stem      | snowball stemmer for irish language
 pg_catalog | italian_stem    | snowball stemmer for italian language
 pg_catalog | lithuanian_stem | snowball stemmer for lithuanian language
 pg_catalog | nepali_stem     | snowball stemmer for nepali language
 pg_catalog | norwegian_stem  | snowball stemmer for norwegian language
 pg_catalog | portuguese_stem | snowball stemmer for portuguese language
 pg_catalog | romanian_stem   | snowball stemmer for romanian language
 pg_catalog | russian_stem    | snowball stemmer for russian language
 pg_catalog | serbian_stem    | snowball stemmer for serbian language
 pg_catalog | simple          | simple dictionary: just lower case and check for stopword
 pg_catalog | spanish_stem    | snowball stemmer for spanish language
 pg_catalog | swedish_stem    | snowball stemmer for swedish language
 pg_catalog | tamil_stem      | snowball stemmer for tamil language
 pg_catalog | turkish_stem    | snowball stemmer for turkish language
 pg_catalog | yiddish_stem    | snowball stemmer for yiddish language

\dFp[+] [PATTERN]

列出文本搜索解析器(添加+以获取更多详细信息)。

=> \dFp
        文本搜索解析器列表
   模式   |  名称   |     描述
------------+---------+---------------------
 pg_catalog | default | 默认单词解析器
=> \dFp+
    文本搜索解析器 "pg_catalog.default"
     方法      |    函数    | 描述
-----------------+----------------+-------------
 开始解析     | prsd_start     |
 获取下一个标记  | prsd_nexttoken |
 结束解析       | prsd_end       |
 获取标题      | prsd_headline  |
 获取标记类型 | prsd_lextype   |

        解析器 "pg_catalog.default" 的标记类型
   标记名称    |               描述
-----------------+------------------------------------------
 asciihword      | 由连字符分隔的单词,全为ASCII
 asciiword       | 单词,全为ASCII
 blank           | 空格符号
 email           | 电子邮件地址
 entity          | XML实体
 file            | 文件或路径名
 float           | 十进制表示
 host            | 主机
 hword           | 由连字符分隔的单词,全为字母
 hword_asciipart | 由连字符分隔的单词部分,全为ASCII
 hword_numpart   | 由连字符分隔的单词部分,字母和数字
 hword_part      | 由连字符分隔的单词部分,全为字母
 int             | 有符号整数
 numhword        | 由连字符分隔的单词,字母和数字
 numword         | 单词,字母和数字
 protocol        | 协议头
 sfloat          | 科学计数法表示
 tag             | XML标记
 uint            | 无符号整数
 url             | URL
 url_path        | URL路径
 version         | 版本号
 word            | 单词,全为字母
(23 行)

\dFt[+] [PATTERN]

列出文本搜索模板(添加+以获取更多详细信息)。

=> \dFt
                           文本搜索模板列表
   模式     |   名称    |                        描述
------------+-----------+-----------------------------------------------------------
 pg_catalog | ispell    | ispell 字典
 pg_catalog | simple    | 简单字典:仅转换为小写并检查停用词
 pg_catalog | snowball  | snowball 词干提取器
 pg_catalog | synonym   | 同义词字典:用同义词替换单词
 pg_catalog | thesaurus | 词库字典:逐句替换