DROP FOREIGN DATA WRAPPER
Function Description
Drops a foreign data wrapper (FDW).
Syntax
DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ]
Parameter Description
name
Specifies the name of an FDW to be dropped.
CASCADE
Automatically drops objects (such as servers) that depend on the FDW.
RESTRICT
Refuses to drop the FDW if there is any dependency on the FDW. This option is the default option.
Examples
--Create an FDW named dbi.
openGauss=# CREATE FOREIGN DATA WRAPPER dbi OPTIONS (debug 'true');
--Drop dbi.
openGauss=# DROP FOREIGN DATA WRAPPER dbi;
Feedback