| 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 9781906966041 | The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference | See the print edition |