1CREATE TEXT SEARCH CONFIGURATION(7S)QL CommandCsREATE TEXT SEARCH CONFIGURATION(7)
2
3
4
6 CREATE TEXT SEARCH CONFIGURATION - define a new text search configura‐
7 tion
8
9
11 CREATE TEXT SEARCH CONFIGURATION name (
12 PARSER = parser_name |
13 COPY = source_config
14 )
15
16
18 CREATE TEXT SEARCH CONFIGURATION creates a new text search configura‐
19 tion. A text search configuration specifies a text search parser that
20 can divide a string into tokens, plus dictionaries that can be used to
21 determine which tokens are of interest for searching.
22
23 If only the parser is specified, then the new text search configuration
24 initially has no mappings from token types to dictionaries, and there‐
25 fore will ignore all words. Subsequent ALTER TEXT SEARCH CONFIGURATION
26 commands must be used to create mappings to make the configuration use‐
27 ful. Alternatively, an existing text search configuration can be
28 copied.
29
30 If a schema name is given then the text search configuration is created
31 in the specified schema. Otherwise it is created in the current schema.
32
33 The user who defines a text search configuration becomes its owner.
34
35 Refer to in the documentation for further information.
36
38 name The name of the text search configuration to be created. The
39 name can be schema-qualified.
40
41 parser_name
42 The name of the text search parser to use for this configura‐
43 tion.
44
45 source_config
46 The name of an existing text search configuration to copy.
47
49 The PARSER and COPY options are mutually exclusive, because when an
50 existing configuration is copied, its parser selection is copied too.
51
53 There is no CREATE TEXT SEARCH CONFIGURATION statement in the SQL stan‐
54 dard.
55
57 ALTER TEXT SEARCH CONFIGURATION [alter_text_search_configuration(7)],
58 DROP TEXT SEARCH CONFIGURATION [drop_text_search_configuration(7)]
59
60
61
62SQL - Language Statements 2014-02-17CREATE TEXT SEARCH CONFIGURATION(7)