| CREATE_TEXT_SEARCH_DICTIONARY(7) - phpMan
CREATE TEXT SEARCH DICTIONARY(7) PostgreSQL 12.3 Documentation CREATE TEXT SEARCH DICTIONARY(7)
NAME
CREATE_TEXT_SEARCH_DICTIONARY - define a new text search dictionary
SYNOPSIS
CREATE TEXT SEARCH DICTIONARY name (
TEMPLATE = template
[, option = value [, ... ]]
)
DESCRIPTION
CREATE TEXT SEARCH DICTIONARY creates a new text search dictionary. A text search
dictionary specifies a way of recognizing interesting or uninteresting words for
searching. A dictionary depends on a text search template, which specifies the functions
that actually perform the work. Typically the dictionary provides some options that
control the detailed behavior of the template's functions.
If a schema name is given then the text search dictionary is created in the specified
schema. Otherwise it is created in the current schema.
The user who defines a text search dictionary becomes its owner.
Refer to Chapter 12 for further information.
PARAMETERS
name
The name of the text search dictionary to be created. The name can be
schema-qualified.
template
The name of the text search template that will define the basic behavior of this
dictionary.
option
The name of a template-specific option to be set for this dictionary.
value
The value to use for a template-specific option. If the value is not a simple
identifier or number, it must be quoted (but you can always quote it, if you wish).
The options can appear in any order.
EXAMPLES
The following example command creates a Snowball-based dictionary with a nonstandard list
of stop words.
CREATE TEXT SEARCH DICTIONARY my_russian (
template = snowball,
language = russian,
stopwords = myrussian
);
COMPATIBILITY
There is no CREATE TEXT SEARCH DICTIONARY statement in the SQL standard.
SEE ALSO
ALTER TEXT SEARCH DICTIONARY (ALTER_TEXT_SEARCH_DICTIONARY(7)), DROP TEXT SEARCH
DICTIONARY (DROP_TEXT_SEARCH_DICTIONARY(7))
PostgreSQL 12.3 2020 CREATE TEXT SEARCH DICTIONARY(7)
|