drop_text_search_dictionary(7) [centos man page]

DROP TEXT SEARCH 
DICTIONARY(7)				  PostgreSQL 9.2.7 Documentation			    DROP TEXT SEARCH DICTIONARY(7)

NAME

       DROP_TEXT_SEARCH_DICTIONARY - remove a text search dictionary

SYNOPSIS

       DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ]

DESCRIPTION

       DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. To execute this command you must be the owner of the dictionary.

PARAMETERS

       IF EXISTS
	   Do not throw an error if the text search dictionary does not exist. A notice is issued in this case.

       name
	   The name (optionally schema-qualified) of an existing text search dictionary.

       CASCADE
	   Automatically drop objects that depend on the text search dictionary.

       RESTRICT
	   Refuse to drop the text search dictionary if any objects depend on it. This is the default.

EXAMPLES

       Remove the text search dictionary english:

	   DROP TEXT SEARCH DICTIONARY english;

       This command will not succeed if there are any existing text search configurations that use the dictionary. Add CASCADE to drop such
       configurations along with the dictionary.

COMPATIBILITY

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

SEE ALSO

       ALTER TEXT SEARCH DICTIONARY (ALTER_TEXT_SEARCH_DICTIONARY(7)), CREATE TEXT SEARCH DICTIONARY (CREATE_TEXT_SEARCH_DICTIONARY(7))

PostgreSQL 9.2.7						    2014-02-17					    DROP TEXT SEARCH DICTIONARY(7)

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 recognizing 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 behavior 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_dictionary(7)]

SQL - Language Statements					    2010-05-14					  CREATE TEXT SEARCH DICTIONARY(7)