1DROP TEXT SEARCH TEMPLATE(7)     SQL Commands     DROP TEXT SEARCH TEMPLATE(7)
2
3
4

NAME

6       DROP TEXT SEARCH TEMPLATE - remove a text search template
7
8

SYNOPSIS

10       DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

14       DROP  TEXT  SEARCH TEMPLATE drops an existing text search template. You
15       must be a superuser to use this command.
16

PARAMETERS

18       IF EXISTS
19              Do not throw an error if  the  text  search  template  does  not
20              exist.  A notice is issued in this case.
21
22       name   The  name  (optionally  schema-qualified)  of  an  existing text
23              search template.
24
25       CASCADE
26              Automatically drop objects that depend on the text  search  tem‐
27              plate.
28
29       RESTRICT
30              Refuse to drop the text search template if any objects depend on
31              it.  This is the default.
32

EXAMPLES

34       Remove the text search template thesaurus:
35
36       DROP TEXT SEARCH TEMPLATE thesaurus;
37
38       This command will not succeed if there are  any  existing  text  search
39       dictionaries that use the template. Add CASCADE to drop such dictionar‐
40       ies along with the template.
41

COMPATIBILITY

43       There is no DROP TEXT SEARCH TEMPLATE statement in the SQL standard.
44

SEE ALSO

46       ALTER TEXT SEARCH TEMPLATE [alter_text_search_template(7)], CREATE TEXT
47       SEARCH TEMPLATE [create_text_search_template(7)]
48
49
50
51SQL - Language Statements         2014-02-17      DROP TEXT SEARCH TEMPLATE(7)