# ALTER_TEXT_SEARCH_DICTIONARY - change the definition of a text search dic... - man(7) - [phpMan]

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

## NAME
       ALTER_TEXT_SEARCH_DICTIONARY - change the definition of a text search dictionary

## SYNOPSIS
       ALTER TEXT SEARCH DICTIONARY _name_ (
           _option_ [ = _value_ ] [, ... ]
       )
       ALTER TEXT SEARCH DICTIONARY _name_ RENAME TO _new_name_
       ALTER TEXT SEARCH DICTIONARY _name_ OWNER TO { _new_owner_ | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
       ALTER TEXT SEARCH DICTIONARY _name_ SET SCHEMA _new_schema_

## DESCRIPTION
       **ALTER TEXT SEARCH DICTIONARY **changes the definition of a text search dictionary. You can
       change the dictionary's template-specific options, or change the dictionary's name or owner.

       You must be the owner of the dictionary to use **ALTER TEXT SEARCH DICTIONARY**.

## PARAMETERS
       _name_
           The name (optionally schema-qualified) of an existing text search dictionary.

       _option_
           The name of a template-specific option to be set for this dictionary.

       _value_
           The new value to use for a template-specific option. If the equal sign and value are
           omitted, then any previous setting for the option is removed from the dictionary,
           allowing the default to be used.

       _new_name_
           The new name of the text search dictionary.

       _new_owner_
           The new owner of the text search dictionary.

       _new_schema_
           The new schema for the text search dictionary.

       Template-specific options can appear in any order.

## EXAMPLES
       The following example command changes the stopword list for a Snowball-based dictionary.
       Other parameters remain unchanged.

           ALTER TEXT SEARCH DICTIONARY my_dict ( StopWords = newrussian );

       The following example command changes the language option to dutch, and removes the stopword
       option entirely.

           ALTER TEXT SEARCH DICTIONARY my_dict ( language = dutch, StopWords );

       The following example command “updates” the dictionary's definition without actually changing
       anything.

           ALTER TEXT SEARCH DICTIONARY my_dict ( dummy );

       (The reason this works is that the option removal code doesn't complain if there is no such
       option.) This trick is useful when changing configuration files for the dictionary: the **ALTER**
       will force existing database sessions to re-read the configuration files, which otherwise
       they would never do if they had read them earlier.

## COMPATIBILITY
       There is no **ALTER TEXT SEARCH DICTIONARY **statement in the SQL standard.

## SEE ALSO
       CREATE TEXT SEARCH DICTIONARY ([**CREATE_TEXT_SEARCH_DICTIONARY**(7)](https://www.chedong.com/phpMan.php/man/CREATETEXTSEARCHDICTIONARY/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                 _ALTER_ _TEXT_ _SEARCH_ [_DICTIONARY_(7)](https://www.chedong.com/phpMan.php/man/DICTIONARY/7/markdown)