12.7. 組態範例
Was this helpful?
Was this helpful?
A text search configuration specifies all options necessary to transform a document into atsvector
: the parser to use to break text into tokens, and the dictionaries to use to transform each token into a lexeme. Every call ofto_tsvector
orto_tsquery
needs a text search configuration to perform its processing. The configuration parameterspecifies the name of the default configuration, which is the one used by text search functions if an explicit configuration parameter is omitted. It can be set inpostgresql.conf
, or set for an individual session using theSET
command.
Several predefined text search configurations are available, and you can create custom configurations easily. To facilitate management of text search objects, a set ofSQLcommands is available, and there are severalpsqlcommands that display information about text search objects ().
As an example we will create a configurationpg
, starting by duplicating the built-inenglish
configuration:
We will use a PostgreSQL-specific synonym list and store it in$SHAREDIR/tsearch_data/pg_dict.syn
. The file contents look like:
We define the synonym dictionary like this:
Next we register theIspelldictionaryenglish_ispell
, which has its own configuration files:
Now we can set up the mappings for words in configurationpg
:
We choose not to index or search some token types that the built-in configuration does handle:
Now we can test our configuration:
The next step is to set the session to use the new configuration, which was created in thepublic
schema: