- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 454 pages
ISBN 9781906966041
RRP £14.95 ($19.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

10.10 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 configurations
 Schema |  Name        | Description
--------+--------------+-------------
 public | fulltext_cfg |
=> \dF *.fulltext*
       List of text search configurations
 Schema   |  Name        | Description
----------+----------------------------
 fulltext | fulltext_cfg |
 public   | fulltext_cfg |

The available commands are:

\dF[+] [PATTERN]
List text search configurations (add + for more detail).
=> \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
 hword_part      | russian_stem
 int             | simple
 numhword        | simple
 numword         | simple
 sfloat          | simple
 uint            | simple
 url             | simple
 url_path        | simple
 version         | simple
 word            | russian_stem
\dFd[+] [PATTERN]
List text search dictionaries (add + for more detail).
=> \dFd
                            List of text search dictionaries
   Schema   |      Name       |
------------+-----------------+
 pg_catalog | danish_stem     |
 pg_catalog | dutch_stem      |
 pg_catalog | english_stem    |
 pg_catalog | finnish_stem    |
 pg_catalog | french_stem     |
 pg_catalog | german_stem     |
 pg_catalog | hungarian_stem  |
 pg_catalog | italian_stem    |
 pg_catalog | norwegian_stem  |
 pg_catalog | portuguese_stem |
 pg_catalog | romanian_stem   |
 pg_catalog | russian_stem    |
 pg_catalog | simple          |
 pg_catalog | spanish_stem    |
 pg_catalog | swedish_stem    |
 pg_catalog | turkish_stem    |
                        Description
-----------------------------------------------------------
 snowball stemmer for danish language
 snowball stemmer for dutch language
 snowball stemmer for english language
 snowball stemmer for finnish language
 snowball stemmer for french language
 snowball stemmer for german language
 snowball stemmer for hungarian language
 snowball stemmer for italian language
 snowball stemmer for norwegian language
 snowball stemmer for portuguese language
 snowball stemmer for romanian language
 snowball stemmer for russian language
 simple dictionary: just lower case and check for stopword
 snowball stemmer for spanish language
 snowball stemmer for swedish language
 snowball stemmer for turkish language
\dFp[+] [PATTERN]
List text search parsers (add + for more detail).
=> \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   |

        Token types for parser "pg_catalog.default"
   Token name    |               Description
-----------------+------------------------------------------
 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
 word            | Word, all letters
(23 rows)
\dFt[+] [PATTERN]
List text search templates (add + for more detail).
=> \dFt
                           List of text search templates
   Schema   |   Name    |
------------+-----------+
 pg_catalog | ispell    |
 pg_catalog | simple    |
 pg_catalog | snowball  |
 pg_catalog | synonym   |
 pg_catalog | thesaurus |
                        Description
-----------------------------------------------------------
 ispell dictionary
 simple dictionary: just lower case and check for stopword
 snowball stemmer
 synonym dictionary: replace word by its synonym
 thesaurus dictionary: phrase by phrase substitution
ISBN 9781906966041The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language ReferenceSee the print edition