The psql command-line utility provides a meta-command to display information about Greenplum Database full text search configurations.

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

1. \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:

1. => \dF *fulltext*
2. List of text search configurations
3. Schema |  Name        | Description
4. --------+--------------+-------------
5. public | fulltext_cfg |

1. => \dF *.fulltext*
2. List of text search configurations
3. Schema   |  Name        | Description
4. ----------+----------------------------
5. fulltext | fulltext_cfg |
6. public   | fulltext_cfg |

The available commands are:

\dF[+] [PATTERN]

List text search configurations (add + for more detail).

1. => \dF russian
2. List of text search configurations
3. Schema   |  Name   |            Description
4. ------------+---------+------------------------------------
5. pg_catalog | russian | configuration for russian language

7. => \dF+ russian
8. Text search configuration "pg_catalog.russian"
9. Parser: "pg_catalog.default"
10. Token      | Dictionaries
11. -----------------+--------------
12. asciihword      | english_stem
13. asciiword       | english_stem
14. email           | simple
15. file            | simple
16. float           | simple
17. host            | simple
18. hword           | russian_stem
19. hword_asciipart | english_stem
20. hword_numpart   | simple
21. hword_part      | russian_stem
22. int             | simple
23. numhword        | simple
24. numword         | simple
25. sfloat          | simple
26. uint            | simple
27. url             | simple
28. url_path        | simple
29. version         | simple
30. word            | russian_stem

\dFd[+] [PATTERN]

List text search dictionaries (add + for more detail).

1. => \dFd
2. List of text search dictionaries
3. Schema   |      Name       |                        Description
4. ------------+-----------------+-----------------------------------------------------------
5. pg_catalog | danish_stem     | snowball stemmer for danish language
6. pg_catalog | dutch_stem      | snowball stemmer for dutch language
7. pg_catalog | english_stem    | snowball stemmer for english language
8. pg_catalog | finnish_stem    | snowball stemmer for finnish language
9. pg_catalog | french_stem     | snowball stemmer for french language
10. pg_catalog | german_stem     | snowball stemmer for german language
11. pg_catalog | hungarian_stem  | snowball stemmer for hungarian language
12. pg_catalog | italian_stem    | snowball stemmer for italian language
13. pg_catalog | norwegian_stem  | snowball stemmer for norwegian language
14. pg_catalog | portuguese_stem | snowball stemmer for portuguese language
15. pg_catalog | romanian_stem   | snowball stemmer for romanian language
16. pg_catalog | russian_stem    | snowball stemmer for russian language
17. pg_catalog | simple          | simple dictionary: just lower case and check for stopword
18. pg_catalog | spanish_stem    | snowball stemmer for spanish language
19. pg_catalog | swedish_stem    | snowball stemmer for swedish language
20. pg_catalog | turkish_stem    | snowball stemmer for turkish language

\dFp[+] [PATTERN]

List text search parsers (add + for more detail).

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   |

16. Token types for parser "pg_catalog.default"
17. Token name    |               Description
18. -----------------+------------------------------------------
19. asciihword      | Hyphenated word, all ASCII
20. asciiword       | Word, all ASCII
21. blank           | Space symbols
22. email           | Email address
23. entity          | XML entity
24. file            | File or path name
25. float           | Decimal notation
26. host            | Host
27. hword           | Hyphenated word, all letters
28. hword_asciipart | Hyphenated word part, all ASCII
29. hword_numpart   | Hyphenated word part, letters and digits
30. hword_part      | Hyphenated word part, all letters
31. int             | Signed integer
32. numhword        | Hyphenated word, letters and digits
33. numword         | Word, letters and digits
34. protocol        | Protocol head
35. sfloat          | Scientific notation
36. tag             | XML tag
37. uint            | Unsigned integer
38. url             | URL
39. url_path        | URL path
40. version         | Version number
41. word            | Word, all letters
42. (23 rows)

\dFt[+] [PATTERN]

List text search templates (add + for more detail).

1. => \dFt
2. List of text search templates
3. Schema   |   Name    |                        Description
4. ------------+-----------+-----------------------------------------------------------
5. pg_catalog | ispell    | ispell dictionary
6. pg_catalog | simple    | simple dictionary: just lower case and check for stopword
7. pg_catalog | snowball  | snowball stemmer
8. pg_catalog | synonym   | synonym dictionary: replace word by its synonym
9. pg_catalog | thesaurus | thesaurus dictionary: phrase by phrase substitution

Parent topic: Using Full Text Search