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

FreeBSD Manual Pages

  
 
  

home | help
ALTER TEXT SEARCH CONFIGPostgreSQL 9.6.3 DocALTERaTEXT SEARCH CONFIGURATION(7)

NAME
       ALTER_TEXT_SEARCH_CONFIGURATION - change	the definition of a text
       search configuration

SYNOPSIS
       ALTER TEXT SEARCH CONFIGURATION name
	   ADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]
       ALTER TEXT SEARCH CONFIGURATION name
	   ALTER MAPPING FOR token_type	[, ... ] WITH dictionary_name [, ... ]
       ALTER TEXT SEARCH CONFIGURATION name
	   ALTER MAPPING REPLACE old_dictionary	WITH new_dictionary
       ALTER TEXT SEARCH CONFIGURATION name
	   ALTER MAPPING FOR token_type	[, ... ] REPLACE old_dictionary	WITH new_dictionary
       ALTER TEXT SEARCH CONFIGURATION name
	   DROP	MAPPING	[ IF EXISTS ] FOR token_type [,	... ]
       ALTER TEXT SEARCH CONFIGURATION name RENAME TO new_name
       ALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_USER	| SESSION_USER }
       ALTER TEXT SEARCH CONFIGURATION name SET	SCHEMA new_schema

DESCRIPTION
       ALTER TEXT SEARCH CONFIGURATION changes the definition of a text	search
       configuration. You can modify its mappings from token types to
       dictionaries, or	change the configuration's name	or owner.

       You must	be the owner of	the configuration to use ALTER TEXT SEARCH
       CONFIGURATION.

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

       token_type
	   The name of a token type that is emitted by the configuration's
	   parser.

       dictionary_name
	   The name of a text search dictionary	to be consulted	for the
	   specified token type(s). If multiple	dictionaries are listed, they
	   are consulted in the	specified order.

       old_dictionary
	   The name of a text search dictionary	to be replaced in the mapping.

       new_dictionary
	   The name of a text search dictionary	to be substituted for
	   old_dictionary.

       new_name
	   The new name	of the text search configuration.

       new_owner
	   The new owner of the	text search configuration.

       new_schema
	   The new schema for the text search configuration.

       The ADD MAPPING FOR form	installs a list	of dictionaries	to be
       consulted for the specified token type(s); it is	an error if there is
       already a mapping for any of the	token types. The ALTER MAPPING FOR
       form does the same, but first removing any existing mapping for those
       token types. The	ALTER MAPPING REPLACE forms substitute new_dictionary
       for old_dictionary anywhere the latter appears. This is done for	only
       the specified token types when FOR appears, or for all mappings of the
       configuration when it doesn't. The DROP MAPPING form removes all
       dictionaries for	the specified token type(s), causing tokens of those
       types to	be ignored by the text search configuration. It	is an error if
       there is	no mapping for the token types,	unless IF EXISTS appears.

EXAMPLES
       The following example replaces the english dictionary with the swedish
       dictionary anywhere that	english	is used	within my_config.

	   ALTER TEXT SEARCH CONFIGURATION my_config
	     ALTER MAPPING REPLACE english WITH	swedish;

COMPATIBILITY
       There is	no ALTER TEXT SEARCH CONFIGURATION statement in	the SQL
       standard.

SEE ALSO
       CREATE TEXT SEARCH CONFIGURATION	(CREATE_TEXT_SEARCH_CONFIGURATION(7)),
       DROP TEXT SEARCH	CONFIGURATION (DROP_TEXT_SEARCH_CONFIGURATION(7))

PostgreSQL 9.6.3		     2017   ALTER TEXT SEARCH CONFIGURATION(7)

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

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

home | help