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

FreeBSD Manual Pages

  
 
  

home | help
CREATE TEXT SEARCH TEMPLPostgreSQL 9.6.3 DocumenCREATE TEXT SEARCH TEMPLATE(7)

NAME
       CREATE_TEXT_SEARCH_TEMPLATE - define a new text search template

SYNOPSIS
       CREATE TEXT SEARCH TEMPLATE name	(
	   [ INIT = init_function , ]
	   LEXIZE = lexize_function
       )

DESCRIPTION
       CREATE TEXT SEARCH TEMPLATE creates a new text search template. Text
       search templates	define the functions that implement text search
       dictionaries. A template	is not useful by itself, but must be
       instantiated as a dictionary to be used.	The dictionary typically
       specifies parameters to be given	to the template	functions.

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

       You must	be a superuser to use CREATE TEXT SEARCH TEMPLATE. This
       restriction is made because an erroneous	text search template
       definition could	confuse	or even	crash the server. The reason for
       separating templates from dictionaries is that a	template encapsulates
       the "unsafe" aspects of defining	a dictionary. The parameters that can
       be set when defining a dictionary are safe for unprivileged users to
       set, and	so creating a dictionary need not be a privileged operation.

       Refer to	Chapter	12, Full Text Search, in the documentation for further
       information.

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

       init_function
	   The name of the init	function for the template.

       lexize_function
	   The name of the lexize function for the template.

       The function names can be schema-qualified if necessary.	Argument types
       are not given, since the	argument list for each type of function	is
       predetermined. The lexize function is required, but the init function
       is optional.

       The arguments can appear	in any order, not only the one shown above.

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

SEE ALSO
       ALTER TEXT SEARCH TEMPLATE (ALTER_TEXT_SEARCH_TEMPLATE(7)), DROP	TEXT
       SEARCH TEMPLATE (DROP_TEXT_SEARCH_TEMPLATE(7))

PostgreSQL 9.6.3		     2017	CREATE TEXT SEARCH TEMPLATE(7)

NAME | SYNOPSIS | DESCRIPTION | PARAMETERS | COMPATIBILITY | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=CREATE_TEXT_SEARCH_TEMPLATE&sektion=7&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help