1ALTER TEXT SEARCH CONFIGURATION(7)SQL CommandsALTER TEXT SEARCH CONFIGURATION(7)
2
3
4

NAME

6       ALTER  TEXT  SEARCH  CONFIGURATION  -  change  the definition of a text
7       search configuration
8
9

SYNOPSIS

11       ALTER TEXT SEARCH CONFIGURATION name
12           ADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]
13       ALTER TEXT SEARCH CONFIGURATION name
14           ALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]
15       ALTER TEXT SEARCH CONFIGURATION name
16           ALTER MAPPING REPLACE old_dictionary WITH new_dictionary
17       ALTER TEXT SEARCH CONFIGURATION name
18           ALTER MAPPING FOR token_type [, ... ] REPLACE old_dictionary WITH new_dictionary
19       ALTER TEXT SEARCH CONFIGURATION name
20           DROP MAPPING [ IF EXISTS ] FOR token_type [, ... ]
21       ALTER TEXT SEARCH CONFIGURATION name RENAME TO newname
22       ALTER TEXT SEARCH CONFIGURATION name OWNER TO newowner
23
24

DESCRIPTION

26       ALTER TEXT SEARCH CONFIGURATION changes the definition of a text search
27       configuration.  You can modify its mappings from token types to dictio‐
28       naries, or change the configuration's name or owner.
29
30       You must be the owner of the configuration to  use  ALTER  TEXT  SEARCH
31       CONFIGURATION.
32

PARAMETERS

34       name   The  name  (optionally  schema-qualified)  of  an  existing text
35              search configuration.
36
37       token_type
38              The name of a token type that is emitted by the  configuration's
39              parser.
40
41       dictionary_name
42              The  name  of  a  text search dictionary to be consulted for the
43              specified token type(s). If multiple  dictionaries  are  listed,
44              they are consulted in the specified order.
45
46       old_dictionary
47              The  name of a text search dictionary to be replaced in the map‐
48              ping.
49
50       new_dictionary
51              The name of a text  search  dictionary  to  be  substituted  for
52              old_dictionary.
53
54       newname
55              The new name of the text search configuration.
56
57       newowner
58              The new owner of the text search configuration.
59
60       The  ADD  MAPPING  FOR  form installs a list of dictionaries to be con‐
61       sulted for the specified token type(s); it is  an  error  if  there  is
62       already  a  mapping  for any of the token types.  The ALTER MAPPING FOR
63       form does the same, but first removing any existing mapping  for  those
64       token types.  The ALTER MAPPING REPLACE forms substitute new_dictionary
65       for old_dictionary anywhere the latter appears.  This is done for  only
66       the  specified token types when FOR appears, or for all mappings of the
67       configuration when it doesn't.  The DROP MAPPING form removes all  dic‐
68       tionaries  for  the  specified  token  type(s), causing tokens of those
69       types to be ignored by the text search configuration. It is an error if
70       there is no mapping for the token types, unless IF EXISTS appears.
71

EXAMPLES

73       The  following example replaces the english dictionary with the swedish
74       dictionary anywhere that english is used within my_config.
75
76       ALTER TEXT SEARCH CONFIGURATION my_config
77         ALTER MAPPING REPLACE english WITH swedish;
78
79

COMPATIBILITY

81       There is no ALTER TEXT SEARCH CONFIGURATION statement in the SQL  stan‐
82       dard.
83

SEE ALSO

85       CREATE TEXT SEARCH CONFIGURATION [create_text_search_configuration(7)],
86       DROP TEXT SEARCH CONFIGURATION [drop_text_search_configuration(7)]
87
88
89
90SQL - Language Statements         2011-09-22ALTER TEXT SEARCH CONFIGURATION(7)
Impressum