1ALTER TEXT SEARCH CONFIGURPAoTsItOgNr(e7S)QL 15.4 DocuAmLeTnEtRatTiEoXnT SEARCH CONFIGURATION(7)
2
3
4

NAME

6       ALTER_TEXT_SEARCH_CONFIGURATION - change the definition of a text
7       search configuration
8

SYNOPSIS

10       ALTER TEXT SEARCH CONFIGURATION name
11           ADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]
12       ALTER TEXT SEARCH CONFIGURATION name
13           ALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]
14       ALTER TEXT SEARCH CONFIGURATION name
15           ALTER MAPPING REPLACE old_dictionary WITH new_dictionary
16       ALTER TEXT SEARCH CONFIGURATION name
17           ALTER MAPPING FOR token_type [, ... ] REPLACE old_dictionary WITH new_dictionary
18       ALTER TEXT SEARCH CONFIGURATION name
19           DROP MAPPING [ IF EXISTS ] FOR token_type [, ... ]
20       ALTER TEXT SEARCH CONFIGURATION name RENAME TO new_name
21       ALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
22       ALTER TEXT SEARCH CONFIGURATION name SET SCHEMA new_schema
23

DESCRIPTION

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

PARAMETERS

33       name
34           The name (optionally schema-qualified) of an existing text search
35           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, they
44           are consulted in the specified order.
45
46       old_dictionary
47           The name of a text search dictionary to be replaced in the mapping.
48
49       new_dictionary
50           The name of a text search dictionary to be substituted for
51           old_dictionary.
52
53       new_name
54           The new name of the text search configuration.
55
56       new_owner
57           The new owner of the text search configuration.
58
59       new_schema
60           The new schema for the text search configuration.
61
62       The ADD MAPPING FOR form installs a list of dictionaries to be
63       consulted for the specified token type(s); it is an error if there is
64       already a mapping for any of the token types. The ALTER MAPPING FOR
65       form does the same, but first removing any existing mapping for those
66       token types. The ALTER MAPPING REPLACE forms substitute new_dictionary
67       for old_dictionary anywhere the latter appears. This is done for only
68       the specified token types when FOR appears, or for all mappings of the
69       configuration when it doesn't. The DROP MAPPING form removes all
70       dictionaries for the specified token type(s), causing tokens of those
71       types to be ignored by the text search configuration. It is an error if
72       there is no mapping for the token types, unless IF EXISTS appears.
73

EXAMPLES

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

COMPATIBILITY

82       There is no ALTER TEXT SEARCH CONFIGURATION statement in the SQL
83       standard.
84

SEE ALSO

86       CREATE TEXT SEARCH CONFIGURATION (CREATE_TEXT_SEARCH_CONFIGURATION(7)),
87       DROP TEXT SEARCH CONFIGURATION (DROP_TEXT_SEARCH_CONFIGURATION(7))
88
89
90
91PostgreSQL 15.4                      2023   ALTER TEXT SEARCH CONFIGURATION(7)
Impressum