Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
CREATE T...ICTIONARY(7)	 PostgreSQL 17.5 Documentation CREATE T...ICTIONARY(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	Chapter	12 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))

PostgreSQL 17.5			     2025	       CREATE T...ICTIONARY(7)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=CREATE_TEXT_SEARCH_DICTIONARY&sektion=7&manpath=FreeBSD+Ports+14.3.quarterly>

home | help