drop_text_search_configuration(7)

NAME#

DROP_TEXT_SEARCH_CONFIGURATION - remove a text search configuration

SYNOPSIS#

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

DESCRIPTION#

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

PARAMETERS#

IF EXISTS

name

CASCADE

RESTRICT

EXAMPLES#

Remove the text search configuration my_english:

DROP TEXT SEARCH CONFIGURATION my_english;

This command will not succeed if there are any existing indexes that reference the configuration in to_tsvector calls. Add CASCADE to drop such indexes along with the text search configuration.

COMPATIBILITY#

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

SEE ALSO#

ALTER TEXT SEARCH CONFIGURATION (ALTER_TEXT_SEARCH_CONFIGURATION(7)), CREATE TEXT SEARCH CONFIGURATION (CREATE_TEXT_SEARCH_CONFIGURATION(7))