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
编组 3备份
    openGauss 2024-11-02 02:00:15
    cancel