GNU/Linux |
Debian 7.3.0(Wheezy) |
|
![]() |
DROP_FOREIGN_DATA_WRAPPER(7) |
![]() |
DROP_FOREIGN_DATA_WRAPPER − remove a foreign−data wrapper
DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ]
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.
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.
CASCADE
Automatically drop objects that depend on the foreign−data wrapper (such as servers).
RESTRICT
Refuse to drop the foreign−data wrappers if any objects depend on it. This is the default.
Drop the foreign−data wrapper dbi:
DROP FOREIGN DATA WRAPPER dbi;
DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075−9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.
CREATE FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7)), ALTER FOREIGN DATA WRAPPER (ALTER_FOREIGN_DATA_WRAPPER(7))
![]() |
DROP_FOREIGN_DATA_WRAPPER(7) | ![]() |