psql支持

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

    可选 + 生成更多细节。

    可选参数PATTERN可以是文本搜索对象的名称,指定schema是可选的。 如果省略PATTERN,则将显示有关所有可见对象的信息。 PATTERN可以是正则表达式,可以为schema和对象名称提供单独的模式。 以下示例说明了这一点:

    1. List of text search configurations
    2. Schema | Name | Description
    3. --------+--------------+-------------
    4. public | fulltext_cfg |

    \dF[+] [PATTERN]

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

    1. => \dF russian
    2. List of text search configurations
    3. Schema | Name | Description
    4. ------------+---------+------------------------------------
    5. pg_catalog | russian | configuration for russian language
    6. => \dF+ russian
    7. Text search configuration "pg_catalog.russian"
    8. Parser: "pg_catalog.default"
    9. Token | Dictionaries
    10. -----------------+--------------
    11. asciihword | english_stem
    12. asciiword | english_stem
    13. email | simple
    14. file | simple
    15. float | simple
    16. host | simple
    17. hword | russian_stem
    18. hword_asciipart | english_stem
    19. hword_numpart | simple
    20. int | simple
    21. numhword | simple
    22. numword | simple
    23. sfloat | simple
    24. uint | simple
    25. url | simple
    26. url_path | simple
    27. version | simple
    28. word | russian_stem

    \dFd[+] [PATTERN]

    \dFp[+] [PATTERN]

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

    1. => \dFp
    2. List of text search parsers
    3. Schema | Name | Description
    4. ------------+---------+---------------------
    5. pg_catalog | default | default word parser
    6. => \dFp+
    7. Text search parser "pg_catalog.default"
    8. Method | Function | Description
    9. -----------------+----------------+-------------
    10. Start parse | prsd_start |
    11. Get next token | prsd_nexttoken |
    12. End parse | prsd_end |
    13. Get headline | prsd_headline |
    14. Get token types | prsd_lextype |
    15. -----------------+------------------------------------------
    16. asciihword | Hyphenated word, all ASCII
    17. asciiword | Word, all ASCII
    18. blank | Space symbols
    19. email | Email address
    20. entity | XML entity
    21. file | File or path name
    22. float | Decimal notation
    23. host | Host
    24. hword | Hyphenated word, all letters
    25. hword_asciipart | Hyphenated word part, all ASCII
    26. hword_numpart | Hyphenated word part, letters and digits
    27. hword_part | Hyphenated word part, all letters
    28. int | Signed integer
    29. numhword | Hyphenated word, letters and digits
    30. numword | Word, letters and digits
    31. protocol | Protocol head
    32. sfloat | Scientific notation
    33. tag | XML tag
    34. uint | Unsigned integer
    35. url | URL
    36. url_path | URL path
    37. version | Version number
    38. (23 rows)

    \dFt[+] [PATTERN]

    Parent topic: 使用全文搜索