CREATE TEXT SEARCH DICTIONARY(7)                          SQL Commands                          CREATE TEXT SEARCH DICTIONARY(7)



NAME
       CREATE TEXT SEARCH DICTIONARY - define a new text search dictionary


SYNOPSIS
       CREATE TEXT SEARCH DICTIONARY name (
           TEMPLATE = template
           [, option = value [, ... ]]
       )


DESCRIPTION
       CREATE TEXT SEARCH DICTIONARY creates a new text search dictionary. A text search dictionary specifies a way of recogniz-
       ing interesting or uninteresting words for searching. A dictionary depends on a text search template, which specifies the
       functions that actually perform the work. Typically the dictionary provides some options that control the detailed behav-
       ior of the template's functions.

       If a schema name is given then the text search dictionary is created in the specified schema. Otherwise it is created  in
       the current schema.

       The user who defines a text search dictionary becomes its owner.

       Refer to in the documentation for further information.

PARAMETERS
       name   The name of the text search dictionary to be created. The name can be schema-qualified.

       template
              The name of the text search template that will define the basic behavior of this dictionary.

       option The name of a template-specific option to be set for this dictionary.

       value  The  value  to  use  for a template-specific option. If the value is not a simple identifier or number, it must be
              quoted (but you can always quote it, if you wish).

       The options can appear in any order.

EXAMPLES
       The following example command creates a Snowball-based dictionary with a nonstandard list of stop words.

       CREATE TEXT SEARCH DICTIONARY my_russian (
           template = snowball,
           language = russian,
           stopwords = myrussian
       );


COMPATIBILITY
       There is no CREATE TEXT SEARCH DICTIONARY statement in the SQL standard.

SEE ALSO
       ALTER TEXT SEARCH DICTIONARY [alter_text_search_dictionary(7)], DROP  TEXT  SEARCH  DICTIONARY  [drop_text_search_dictio-
       nary(7)]



SQL - Language Statements                                  2011-09-22                           CREATE TEXT SEARCH DICTIONARY(7)