关于文本搜索配置对象的信息可以在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 | 词库字典:逐句替换