drop_text_search_dictionary(7)

NAME#

DROP_TEXT_SEARCH_DICTIONARY - remove a text search dictionary

SYNOPSIS#

DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] \nname\n [ CASCADE | RESTRICT ]

DESCRIPTION#

DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. To execute this command you must be the owner of the dictionary.

PARAMETERS#

IF EXISTS

name

CASCADE

RESTRICT

EXAMPLES#

Remove the text search dictionary english:

DROP TEXT SEARCH DICTIONARY english;

This command will not succeed if there are any existing text search configurations that use the dictionary. Add CASCADE to drop such configurations along with the dictionary.

COMPATIBILITY#

There is no DROP TEXT SEARCH DICTIONARY statement in the SQL standard.

SEE ALSO#

ALTER TEXT SEARCH DICTIONARY (ALTER_TEXT_SEARCH_DICTIONARY(7)), CREATE TEXT SEARCH DICTIONARY (CREATE_TEXT_SEARCH_DICTIONARY(7))