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

NAME

6       CREATE TEXT SEARCH DICTIONARY - define a new text search dictionary
7
8

SYNOPSIS

10       CREATE TEXT SEARCH DICTIONARY name (
11           TEMPLATE = template
12           [, option = value [, ... ]]
13       )
14
15

DESCRIPTION

17       CREATE  TEXT  SEARCH DICTIONARY creates a new text search dictionary. A
18       text search dictionary specifies a way of  recognizing  interesting  or
19       uninteresting  words  for  searching.  A  dictionary  depends on a text
20       search template, which specifies the functions  that  actually  perform
21       the  work.  Typically the dictionary provides some options that control
22       the detailed behavior of the template's functions.
23
24       If a schema name is given then the text search dictionary is created in
25       the specified schema. Otherwise it is created in the current schema.
26
27       The user who defines a text search dictionary becomes its owner.
28
29       Refer to in the documentation for further information.
30

PARAMETERS

32       name   The  name  of the text search dictionary to be created. The name
33              can be schema-qualified.
34
35       template
36              The name of the text search template that will define the  basic
37              behavior of this dictionary.
38
39       option The  name  of a template-specific option to be set for this dic‐
40              tionary.
41
42       value  The value to use for a template-specific option. If the value is
43              not  a  simple  identifier or number, it must be quoted (but you
44              can always quote it, if you wish).
45
46       The options can appear in any order.
47

EXAMPLES

49       The following example command creates a Snowball-based dictionary  with
50       a nonstandard list of stop words.
51
52       CREATE TEXT SEARCH DICTIONARY my_russian (
53           template = snowball,
54           language = russian,
55           stopwords = myrussian
56       );
57
58

COMPATIBILITY

60       There  is  no  CREATE TEXT SEARCH DICTIONARY statement in the SQL stan‐
61       dard.
62

SEE ALSO

64       ALTER TEXT SEARCH  DICTIONARY  [alter_text_search_dictionary(7)],  DROP
65       TEXT SEARCH DICTIONARY [drop_text_search_dictionary(7)]
66
67
68
69SQL - Language Statements         2014-02-17  CREATE TEXT SEARCH DICTIONARY(7)