1DROP SERVER(7)           PostgreSQL 12.6 Documentation          DROP SERVER(7)
2
3
4

NAME

6       DROP_SERVER - remove a foreign server descriptor
7

SYNOPSIS

9       DROP SERVER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
10

DESCRIPTION

12       DROP SERVER removes an existing foreign server descriptor. To execute
13       this command, the current user must be the owner of the server.
14

PARAMETERS

16       IF EXISTS
17           Do not throw an error if the server does not exist. A notice is
18           issued in this case.
19
20       name
21           The name of an existing server.
22
23       CASCADE
24           Automatically drop objects that depend on the server (such as user
25           mappings), and in turn all objects that depend on those objects
26           (see Section 5.14).
27
28       RESTRICT
29           Refuse to drop the server if any objects depend on it. This is the
30           default.
31

EXAMPLES

33       Drop a server foo if it exists:
34
35           DROP SERVER IF EXISTS foo;
36

COMPATIBILITY

38       DROP SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause
39       is a PostgreSQL extension.
40

SEE ALSO

42       CREATE SERVER (CREATE_SERVER(7)), ALTER SERVER (ALTER_SERVER(7))
43
44
45
46PostgreSQL 12.6                      2021                       DROP SERVER(7)
Impressum