NameDROP EVENT TRIGGER -- remove an event trigger Synopsis DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP EVENT TRIGGER removes an existing event trigger. To execute this command, the current user must be the owner of the event trigger. Parameters IF EXISTS Do not throw an error if the event trigger does not exist. A notice is issued in this case. name The name of the event trigger to remove. CASCADE Automatically drop objects that depend on the

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 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 connected to the target database. (Connect to postgres or any other database to issue this command.) DROP DATABASE cannot be undone. Use it with care! Parameters

NameDROP 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 is issued in this case. name The name of the conversion. The conversion name can be schema-qualified. CASCADERESTRICT These key words do not have any e

NameDROP 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 issued in this case. name The name of the collation. The collation name can be schema-qualified. CASCADE Automatically drop objects that depend on the collati

NameDROP CAST -- remove a cast Synopsis DROP CAST [ IF EXISTS ] (source_type AS target_type) [ 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 create a cast. Parameters IF EXISTS Do not throw an error if the cast does not exist. A notice is issued in this case. source_type The name of the source data type of the cast. targ

NameDROP AGGREGATE -- remove an aggregate function Synopsis DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [ CASCADE | RESTRICT ] where aggregate_signature is: * | [ argmode ] [ argname ] argtype [ , ... ] | [ [ argmode ] [ argname ] argtype [ , ... ] ] ORDER BY [ argmode ] [ argname ] argtype [ , ... ] 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

NameDROP ACCESS METHOD -- remove an access method Synopsis DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP ACCESS METHOD removes an existing access method. Only superusers can drop access methods. Parameters IF EXISTS Do not throw an error if the access method does not exist. A notice is issued in this case. name The name of an existing access method. CASCADE Automatically drop objects that depend on the access method (such as operator classes, o

NameDO -- 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 and executed a single time. The optional LANGUAGE clause can be written either before or after the code block. Parameters code The procedural language code to be

NameDISCARD -- discard session state Synopsis DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP } Description DISCARD releases internal resources associated with a database session. This command is useful for partially or fully resetting the session's state. There are several subcommands to release different types of resources; the DISCARD ALL variant subsumes all the others, and also resets additional state. Parameters PLANS Releases all cached query plans, forcing re-plannin