1DROP FOREIGN DATA WRAPPER(7)     SQL Commands     DROP FOREIGN DATA WRAPPER(7)
2
3
4

NAME

6       DROP FOREIGN DATA WRAPPER - remove a foreign-data wrapper
7
8

SYNOPSIS

10       DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

14       DROP  FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. To
15       execute this command, the current user must be the owner  of  the  for‐
16       eign-data wrapper.
17

PARAMETERS

19       IF EXISTS
20              Do  not  throw  an  error  if  the foreign-data wrapper does not
21              exist. A notice is issued in this case.
22
23       name   The name of an existing foreign-data wrapper.
24
25       CASCADE
26              Automatically drop objects that depend on the foreign-data wrap‐
27              per (such as servers).
28
29       RESTRICT
30              Refuse  to  drop the foreign-data wrappers if any objects depend
31              on it. This is the default.
32

EXAMPLES

34       Drop the foreign-data wrapper dbi:
35
36       DROP FOREIGN DATA WRAPPER dbi;
37
38

COMPATIBILITY

40       DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). The  IF
41       EXISTS clause is a PostgreSQL extension.
42

SEE ALSO

44       CREATE  FOREIGN  DATA  WRAPPER  [create_foreign_data_wrapper(7)], ALTER
45       FOREIGN DATA WRAPPER [alter_foreign_data_wrapper(7)]
46
47
48
49SQL - Language Statements         2014-02-17      DROP FOREIGN DATA WRAPPER(7)