在 psql（PostgreSQL 的交互式终端）中，你可以使用一系列命令来获取有关文本搜索配置对象的信息。这些命令主要围绕 \dF 系列，以及使用 SQL 查询 pg_ts_config 系统视图。以下是你可以使用的一些方法：

使用 \dF 系列命令

1. \dF 或 \dF+：

   • \dF 列出所有文本搜索配置（text search configurations）。
   • \dF+ 提供关于每个文本搜索配置的更多详细信息。

2. \dFp 或 \dFp+：

   • \dFp 列出所有文本搜索配置，但只显示那些属于特定模式（schema）的文本搜索配置，如果你指定了一个模式的话。
   • \dFp+ 提供关于这些配置的更多详细信息。

使用 SQL 查询

你也可以直接运行 SQL 查询来获取关于文本搜索配置的信息。以下是一些常用的查询：

1. 查询所有文本搜索配置：

   SELECT * FROM pg_ts_config;
   

2. 查询特定模式的文本搜索配置：

   SELECT * FROM pg_ts_config WHERE schemaname = 'your_schema_name';
   

3. 查看文本搜索配置的详细信息：

   SELECT cfgname, cfgowner, cfgnamespace::regnamespace::text AS schemaname, cfgparser::regproc::text AS parser
   FROM pg_ts_config;
   

4. 查看与特定文本搜索配置关联的解析器：

   SELECT cfgname, cfgparser::regproc::text AS parser
   FROM pg_ts_config
   WHERE cfgname = 'your_config_name';
   

示例

假设你有一个名为 english 的文本搜索配置，并且你想获取关于它的详细信息，你可以这样做：

1. 使用 \dF+ 命令：

   \dF+ english
   

2. 使用 SQL 查询：

   SELECT * FROM pg_ts_config WHERE cfgname = 'english';
   

这些命令和查询将帮助你获取有关 PostgreSQL 数据库中文本搜索配置对象的信息，包括它们的名称、所有者、所属模式以及它们使用的解析器等。

psql Support

Information about text search configuration objects can be obtained in psql using a set of commands:

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

An optional + produces more details.

The optional parameter PATTERN can be the name of a text search object, optionally schema-qualified. If PATTERN is omitted then information about all visible objects will be displayed. PATTERN can be a regular expression and can provide separate patterns for the schema and object names. The following examples illustrate this:

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

\dF[+] [PATTERN]
List text search configurations (add + for more detail).

=> \dF russianList of text search configurationsSchema   |  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_stemasciiword       | english_stememail           | simplefile            | simplefloat           | simplehost            | simplehword           | russian_stemhword_asciipart | english_stemhword_numpart   | simplehword_part      | russian_stemint             | simplenumhword        | simplenumword         | simplesfloat          | simpleuint            | simpleurl             | simpleurl_path        | simpleversion         | simpleword            | russian_stem

\dFd[+] [PATTERN]
List text search dictionaries (add + for more detail).

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

\dFp[+] [PATTERN]
List text search parsers (add + for more detail).

=> \dFpList of text search parsersSchema   |  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   |Token types for parser "pg_catalog.default"Token name    |               Description
-----------------+------------------------------------------asciihword      | Hyphenated word, all ASCIIasciiword       | Word, all ASCIIblank           | Space symbolsemail           | Email addressentity          | XML entityfile            | File or path namefloat           | Decimal notationhost            | Hosthword           | Hyphenated word, all lettershword_asciipart | Hyphenated word part, all ASCIIhword_numpart   | Hyphenated word part, letters and digitshword_part      | Hyphenated word part, all lettersint             | Signed integernumhword        | Hyphenated word, letters and digitsnumword         | Word, letters and digitsprotocol        | Protocol headsfloat          | Scientific notationtag             | XML taguint            | Unsigned integerurl             | URLurl_path        | URL pathversion         | Version numberword            | Word, all letters
(23 rows)

\dFt[+] [PATTERN]
List text search templates (add + for more detail).

=> \dFtList of text search templatesSchema   |   Name    |                        Description
------------+-----------+-----------------------------------------------------------pg_catalog | ispell    | ispell dictionarypg_catalog | simple    | simple dictionary: just lower case and check for stopwordpg_catalog | snowball  | snowball stemmerpg_catalog | synonym   | synonym dictionary: replace word by its synonympg_catalog | thesaurus | thesaurus dictionary: phrase by phrase substitution