1CREATE TEXT SEARCH CONFIGUPRoAsTtIgOrNe(S7Q)L 11.6 DocCuRmEeAnTtEatTiEoXnT SEARCH CONFIGURATION(7)
2
3
4
6 CREATE_TEXT_SEARCH_CONFIGURATION - define a new text search
7 configuration
8
10 CREATE TEXT SEARCH CONFIGURATION name (
11 PARSER = parser_name |
12 COPY = source_config
13 )
14
16 CREATE TEXT SEARCH CONFIGURATION creates a new text search
17 configuration. A text search configuration specifies a text search
18 parser that can divide a string into tokens, plus dictionaries that can
19 be used to determine which tokens are of interest for searching.
20
21 If only the parser is specified, then the new text search configuration
22 initially has no mappings from token types to dictionaries, and
23 therefore will ignore all words. Subsequent ALTER TEXT SEARCH
24 CONFIGURATION commands must be used to create mappings to make the
25 configuration useful. Alternatively, an existing text search
26 configuration can be copied.
27
28 If a schema name is given then the text search configuration is created
29 in the specified schema. Otherwise it is created in the current schema.
30
31 The user who defines a text search configuration becomes its owner.
32
33 Refer to Chapter 12 for further information.
34
36 name
37 The name of the text search configuration to be created. The name
38 can be schema-qualified.
39
40 parser_name
41 The name of the text search parser to use for this configuration.
42
43 source_config
44 The name of an existing text search configuration to copy.
45
47 The PARSER and COPY options are mutually exclusive, because when an
48 existing configuration is copied, its parser selection is copied too.
49
51 There is no CREATE TEXT SEARCH CONFIGURATION statement in the SQL
52 standard.
53
55 ALTER TEXT SEARCH CONFIGURATION (ALTER_TEXT_SEARCH_CONFIGURATION(7)),
56 DROP TEXT SEARCH CONFIGURATION (DROP_TEXT_SEARCH_CONFIGURATION(7))
57
58
59
60PostgreSQL 11.6 2019 CREATE TEXT SEARCH CONFIGURATION(7)