Man Linux: Main Page and Category List

NAME

       DROP SERVER - remove a foreign server descriptor

SYNOPSIS

       DROP SERVER [ IF EXISTS ] servername [ CASCADE | RESTRICT ]

DESCRIPTION

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

PARAMETERS

       IF EXISTS
              Do not throw an error if the server does not exist. A notice  is
              issued in this case.

       servername
              The name of an existing server.

       CASCADE
              Automatically  drop  objects  that depend on the server (such as
              user mappings).

       RESTRICT
              Refuse to drop the server if any objects depend on it.  This  is
              the default.

EXAMPLES

       Drop a server foo if it exists:

       DROP SERVER IF EXISTS foo;

COMPATIBILITY

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

SEE ALSO

       CREATE SERVER [create_server(7)], ALTER SERVER [alter_server(7)]