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

  
 
  

home | help
DROP TEX...ICTIONARY(7)   PostgreSQL 18.6 Documentation  DROP TEX...ICTIONARY(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 dic-
	 tionary.

     CASCADE
	 Automatically drop objects that depend on the text  search  dictionary,
	 and  in  turn	all  objects  that  depend  on	those  objects (see Sec-
	 tion 5.15).

     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 config-
     urations  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 18.6 		      2026		 DROP TEX...ICTIONARY(7)

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

home | help