1DROP SERVER(7)          PostgreSQL 9.2.24 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).
26
27       RESTRICT
28           Refuse to drop the server if any objects depend on it. This is the
29           default.
30

EXAMPLES

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

COMPATIBILITY

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

SEE ALSO

41       CREATE SERVER (CREATE_SERVER(7)), ALTER SERVER (ALTER_SERVER(7))
42
43
44
45PostgreSQL 9.2.24                 2017-11-06                    DROP SERVER(7)
Impressum