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

NameDROP 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 an error if the extension does not exist. A notice is issued in this case. name The name of an installed extension. CASCADE Automatically dro

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 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

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 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 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

dict_int is an example of an add-on dictionary template for full-text search. The motivation for this example dictionary is to control the indexing of integers (signed and unsigned), allowing such numbers to be indexed while preventing excessive growth in the number of unique words, which greatly affects the performance of searching. F.11.1. Configuration The dictionary accepts two options: The maxlen parameter specifies the maximum number of digits allowed in an integer word. The default val

When you create complex database structures involving many tables with foreign key constraints, views, triggers, functions, etc. you implicitly create a net of dependencies between the objects. For instance, a table with a foreign key constraint depends on the table it references. To ensure the integrity of the entire database structure, PostgreSQL makes sure that you cannot drop objects that other objects still depend on. For example, attempting to drop the products table we considered in Sect