# CREATE_TEXT_SEARCH_DICTIONARY - define a new text search dictionary - man(7) - [phpMan]

_CREATE_ _TEXT_ _SEARCH_ [_DICTIONARY_(7)](https://www.chedong.com/phpMan.php/man/DICTIONARY/7/markdown)   PostgreSQL 16.14 Documentation   _CREATE_ _TEXT_ _SEARCH_ [_DICTIONARY_(7)](https://www.chedong.com/phpMan.php/man/DICTIONARY/7/markdown)

## 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)](https://www.chedong.com/phpMan.php/man/ALTERTEXTSEARCHDICTIONARY/7/markdown)), DROP TEXT SEARCH DICTIONARY
       ([**DROP_TEXT_SEARCH_DICTIONARY**(7)](https://www.chedong.com/phpMan.php/man/DROPTEXTSEARCHDICTIONARY/7/markdown))

PostgreSQL 16.14                                2026                _CREATE_ _TEXT_ _SEARCH_ [_DICTIONARY_(7)](https://www.chedong.com/phpMan.php/man/DICTIONARY/7/markdown)