1ALTER TEXT SEARCH DICTIONARY(7)  SQL Commands  ALTER TEXT SEARCH DICTIONARY(7)
2
3
4

NAME

6       ALTER  TEXT  SEARCH DICTIONARY - change the definition of a text search
7       dictionary
8
9

SYNOPSIS

11       ALTER TEXT SEARCH DICTIONARY name (
12           option [ = value ] [, ... ]
13       )
14       ALTER TEXT SEARCH DICTIONARY name RENAME TO newname
15       ALTER TEXT SEARCH DICTIONARY name OWNER TO newowner
16
17

DESCRIPTION

19       ALTER TEXT SEARCH DICTIONARY changes the definition of  a  text  search
20       dictionary.  You can change the dictionary's template-specific options,
21       or change the dictionary's name or owner.
22
23       You must be the owner of the dictionary to use ALTER TEXT  SEARCH  DIC‐
24       TIONARY.
25

PARAMETERS

27       name   The  name  (optionally  schema-qualified)  of  an  existing text
28              search dictionary.
29
30       option The name of a template-specific option to be set for  this  dic‐
31              tionary.
32
33       value  The  new  value  to  use for a template-specific option.  If the
34              equal sign and value are omitted, then any previous setting  for
35              the  option is removed from the dictionary, allowing the default
36              to be used.
37
38       newname
39              The new name of the text search dictionary.
40
41       newowner
42              The new owner of the text search dictionary.
43
44       Template-specific options can appear in any order.
45

EXAMPLES

47       The following example command changes the stopword list for a Snowball-
48       based dictionary. Other parameters remain unchanged.
49
50       ALTER TEXT SEARCH DICTIONARY my_dict ( StopWords = newrussian );
51
52
53       The following example command changes the language option to dutch, and
54       removes the stopword option entirely.
55
56       ALTER TEXT SEARCH DICTIONARY my_dict ( language = dutch, StopWords );
57
58
59       The following example command ``updates'' the  dictionary's  definition
60       without actually changing anything.
61
62       ALTER TEXT SEARCH DICTIONARY my_dict ( dummy );
63
64       (The reason this works is that the option removal code doesn't complain
65       if there is no such option.) This trick is useful when changing config‐
66       uration  files  for the dictionary: the ALTER will force existing data‐
67       base sessions to re-read the configuration files, which otherwise  they
68       would never do if they had read them earlier.
69

COMPATIBILITY

71       There is no ALTER TEXT SEARCH DICTIONARY statement in the SQL standard.
72

SEE ALSO

74       CREATE  TEXT SEARCH DICTIONARY [create_text_search_dictionary(7)], DROP
75       TEXT SEARCH DICTIONARY [drop_text_search_dictionary(7)]
76
77
78
79SQL - Language Statements         2014-02-17   ALTER TEXT SEARCH DICTIONARY(7)
Impressum