NameDROP OPERATOR FAMILY -- remove an operator family Synopsis DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] Description DROP OPERATOR FAMILY drops an existing operator family. To execute this command you must be the owner of the operator family. DROP OPERATOR FAMILY includes dropping any operator classes contained in the family, but it does not drop any of the operators or functions referenced by the family. If there are any indexes depending on op

NameDROP OPERATOR CLASS -- remove an operator class Synopsis DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] Description DROP OPERATOR CLASS drops an existing operator class. To execute this command you must be the owner of the operator class. DROP OPERATOR CLASS does not drop any of the operators or functions referenced by the class. If there are any indexes depending on the operator class, you will need to specify CASCADE for the drop to complete.

NameDROP OPERATOR -- remove an operator Synopsis DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , { right_type | NONE } ) [ CASCADE | RESTRICT ] Description DROP OPERATOR drops an existing operator from the database system. To execute this command you must be the owner of the operator. Parameters IF EXISTS Do not throw an error if the operator does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing operator. left_typ

NameDROP GROUP -- remove a database role Synopsis DROP GROUP [ IF EXISTS ] name [, ...] Description DROP GROUP is now an alias for DROP ROLE. Compatibility There is no DROP GROUP statement in the SQL standard. See Also DROP ROLE Prev Next DROP FUNCTION Up DROP INDEX

NameDROP INDEX -- remove an index Synopsis DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] Description DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index. Parameters CONCURRENTLY Drop the index without locking out concurrent selects, inserts, updates, and deletes on the index's table. A normal DROP INDEX acquires exclusive lock on the table, blocking other accesses until the index d

NameDROP LANGUAGE -- remove a procedural language Synopsis DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP LANGUAGE removes the definition of a previously registered procedural language. You must be a superuser or the owner of the language to use DROP LANGUAGE. Note: As of PostgreSQL 9.1, most procedural languages have been made into "extensions", and should therefore be removed with DROP EXTENSION not DROP LANGUAGE. Parameters IF EXISTS

NameDROP FOREIGN TABLE -- remove a foreign table Synopsis DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] Description DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it. Parameters IF EXISTS Do not throw an error if the foreign table does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the foreign table to drop. CASCADE Automatically drop objects that depend on the foreign

NameDROP FUNCTION -- remove a function Synopsis DROP FUNCTION [ IF EXISTS ] name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) [ CASCADE | RESTRICT ] Description DROP FUNCTION removes the definition of an existing function. To execute this command the user must be the owner of the function. The argument types to the function must be specified, since several different functions can exist with the same name and different argument lists. Parameters IF EXISTS Do not throw an er

NameDROP DOMAIN -- remove a domain Synopsis DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] Description DROP DOMAIN removes a domain. Only the owner of a domain can remove it. Parameters IF EXISTS Do not throw an error if the domain does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing domain. CASCADE Automatically drop objects that depend on the domain (such as table columns), and in turn all objects that de

NameDROP FOREIGN DATA WRAPPER -- remove a foreign-data wrapper Synopsis DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. To execute this command, the current user must be the owner of the foreign-data wrapper. Parameters IF EXISTS Do not throw an error if the foreign-data wrapper does not exist. A notice is issued in this case. name The name of an existing foreign-data wrapper. C