DROP 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…
DROP OPERATOR – remove an operator Synopsis DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | 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….
DROP 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. Parameters IF EXISTS Do not…
DROP INDEX – remove an index Synopsis DROP INDEX [ 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 IF EXISTS Do not throw an error if the index…
DROP_GROUP – remove a database role Synopsis DROP GROUP [ IF EXISTS ] name [, …] Description DROP GROUP is now an alias for DROP ROLE (DROP_ROLE(7)). Compatibility There is no DROP GROUP statement in the SQL standard. See Also DROP ROLE (DROP_ROLE(7))
DROP 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….
DROP_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….
DROP 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…
DROP_EXTENSION – remove an extension Synopsis DROP EXTENSION [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP EXTENSION removes extensions from the database. Dropping an extension causes its component objects to be dropped as well. You must own the extension to use DROP EXTENSION. Parameters IF EXISTS Do not throw…
DROP 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…
DROP DATABASE – remove a database Synopsis DROP DATABASE [ IF EXISTS ] name Description DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. Also, it cannot be executed while you or anyone else are…
DROP CONVERSION – remove a conversion Synopsis DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you must own the conversion. Parameters IF EXISTS Do not throw an error if the conversion does not exist. A notice…
DROP_COLLATION – remove a collation Synopsis DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP COLLATION removes a previously defined collation. To be able to drop a collation, you must own the collation. Parameters IF EXISTS Do not throw an error if the collation does not exist. A notice is…
DROP CAST – remove a cast Synopsis DROP CAST [ IF EXISTS ] (sourcetype AS targettype) [ CASCADE | RESTRICT ] Description DROP CAST removes a previously defined cast. To be able to drop a cast, you must own the source or the target data type. These are the same privileges that are required to…
DROP AGGREGATE – remove an aggregate function Synopsis DROP AGGREGATE [ IF EXISTS ] name ( type [ , … ] ) [ CASCADE | RESTRICT ] Description DROP AGGREGATE removes an existing aggregate function. To execute this command the current user must be the owner of the aggregate function. Parameters IF EXISTS Do not…
DO – execute an anonymous code block Synopsis DO [ LANGUAGE lang_name ] code Description DO executes an anonymous code block, or in other words a transient anonymous function in a procedural language. The code block is treated as though it were the body of a function with no parameters, returning void. It is parsed…
DISCARD – discard session state Synopsis DISCARD { ALL | PLANS | TEMPORARY | TEMP } Description DISCARD releases internal resources associated with a database session. These resources are normally released at the end of the session. DISCARD TEMP drops all temporary tables created in the current session. DISCARD PLANS releases all internally cached query…
DELETE – delete rows of a table Synopsis DELETE FROM [ ONLY ] table [ [ AS ] alias ] [ USING usinglist ] [ WHERE condition | WHERE CURRENT OF cursor_name ] [ RETURNING * | output_expression [ [ AS ] output_name ] [, …] ] Description DELETE deletes rows that satisfy the WHERE…
DECLARE – define a cursor Synopsis DECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query Description DECLARE allows a user to create cursors, which can be used to retrieve a small number of rows at a time out of…
DEALLOCATE – deallocate a prepared statement Synopsis DEALLOCATE [ PREPARE ] { name | ALL } Description DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends. For more information on prepared statements, see PREPARE [prepare(7)]. Parameters PREPARE This…