psql支持
可以使用一组命令在psql中获取有关文本搜索配置对象的信息:
可选 + 生成更多细节。
可选参数PATTERN可以是文本搜索对象的名称,指定schema是可选的。 如果省略PATTERN,则将显示有关所有可见对象的信息。 PATTERN可以是正则表达式,可以为schema和对象名称提供单独的模式。 以下示例说明了这一点:
List of text search configurations
Schema | Name | Description
--------+--------------+-------------
public | fulltext_cfg |
\dF[+] [PATTERN]
列出文本搜索配置(添加 + 以获取更多详细信息)。
=> \dF russian
List of text search configurations
Schema | Name | Description
------------+---------+------------------------------------
pg_catalog | russian | configuration for russian language
=> \dF+ russian
Text search configuration "pg_catalog.russian"
Parser: "pg_catalog.default"
Token | Dictionaries
-----------------+--------------
asciihword | english_stem
asciiword | english_stem
email | simple
file | simple
float | simple
host | simple
hword | russian_stem
hword_asciipart | english_stem
hword_numpart | simple
int | simple
numhword | simple
numword | simple
sfloat | simple
uint | simple
url | simple
url_path | simple
version | simple
word | russian_stem
\dFd[+] [PATTERN]
\dFp[+] [PATTERN]
列出文本搜索解析器(添加 + 以获取更多详细信息)。
=> \dFp
List of text search parsers
Schema | Name | Description
------------+---------+---------------------
pg_catalog | default | default word parser
=> \dFp+
Text search parser "pg_catalog.default"
Method | Function | Description
-----------------+----------------+-------------
Start parse | prsd_start |
Get next token | prsd_nexttoken |
End parse | prsd_end |
Get headline | prsd_headline |
Get token types | prsd_lextype |
-----------------+------------------------------------------
asciihword | Hyphenated word, all ASCII
asciiword | Word, all ASCII
blank | Space symbols
email | Email address
entity | XML entity
file | File or path name
float | Decimal notation
host | Host
hword | Hyphenated word, all letters
hword_asciipart | Hyphenated word part, all ASCII
hword_numpart | Hyphenated word part, letters and digits
hword_part | Hyphenated word part, all letters
int | Signed integer
numhword | Hyphenated word, letters and digits
numword | Word, letters and digits
protocol | Protocol head
sfloat | Scientific notation
tag | XML tag
uint | Unsigned integer
url | URL
url_path | URL path
version | Version number
(23 rows)
\dFt[+] [PATTERN]
Parent topic: 使用全文搜索