Information about text search configuration objects can be obtained inpsqlusing a set of commands:
\dF{d,p,t}[+] [PATTERN]
An optional+
produces more details.
The optional parameterPATTERN
_can be the name of a text search object, optionally schema-qualified. IfPATTERN
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 |
The available commands are:
\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+ russianText 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 | 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 | hungarian_stem | snowball stemmer for hungarian languagepg_catalog | italian_stem | snowball stemmer for italian 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 | 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 | turkish_stem | snowball stemmer for turkish 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