What are the possible regconfig values ​​in postgresql?

Question

• http://www.postgresql.org/docs/9.3/static/textsearch-controls.html often refers to the optional regconfig parameter, but I can not find its possible values ​​and their values. Where is this documented? If this is not possible to answer (for example, since it depends on my installed database components or how), how can I determine this myself?

• I need a reconfiguration of the "plain text" without any transformations in the human language. What is the argument for this?

Answer 1

A text search configuration is a grouping of configuration objects: parsers, templates, and dictionaries. As far as I can tell, the only built-in configuration options are language ones, such as English or Finnish.

You can view the list of configurations in your database using the \dF command in the psql command-line tool or using the query: select * from pg_catalog.pg_ts_config;

Regarding the “plain text” configuration (# 2), I'm not sure what you need, but look at creating a custom dictionary. Perhaps start with the built-in "simple" dictionary and delete the stop words? COMMENT ON TEXT SEARCH DICTIONARY simple IS 'simple dictionary: just lower case and check for stopword';

Link: Configurations