DROP TEXT SEARCH TEMPLATE() SQL Commands DROP TEXT SEARCH TEMPLATE()
NAME
DROP TEXT SEARCH TEMPLATE - remove a text search template
SYNOPSIS
DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TEXT SEARCH TEMPLATE drops an existing text search template. You
must be a superuser to use this command.
PARAMETERS
IF EXISTS
Do not throw an error if the text search template does not
exist. A notice is issued in this case.
name The name (optionally schema-qualified) of an existing text
search template.
CASCADE
Automatically drop objects that depend on the text search tem-
plate.
RESTRICT
Refuse to drop the text search template if any objects depend on
it. This is the default.
EXAMPLES
Remove the text search template thesaurus:
DROP TEXT SEARCH TEMPLATE thesaurus;
This command will not succeed if there are any existing text search
dictionaries that use the template. Add CASCADE to drop such dictionar-
ies along with the template.
COMPATIBILITY
There is no DROP TEXT SEARCH TEMPLATE statement in the SQL standard.
SEE ALSO
ALTER TEXT SEARCH TEMPLATE [alter_text_search_template(l)], CREATE TEXT
SEARCH TEMPLATE [create_text_search_template(l)]
SQL - Language Statements 2008-09-19 DROP TEXT SEARCH TEMPLATE()
postgresql 8.3.4 - Generated Fri Oct 3 20:24:27 CDT 2008