Contents

DROP SERVER

An SQL command for removing a foreign server

DROP SERVER is a DDL command for removing a foreign server.

DROP SERVER was added in PostgreSQL 8.4.

Change history

DROP SERVER has not been modified since it was added in PostgreSQL 8.4.

Examples

Basic usage example for DROP SERVER:

postgres=# DROP SERVER pg_fdw_test;
ERROR:  cannot drop server pg_fdw_test because other objects depend on it
DETAIL:  user mapping for postgres on server pg_fdw_test depends on server pg_fdw_test
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

postgres=# DROP SERVER pg_fdw_test CASCADE;
NOTICE:  drop cascades to user mapping for postgres on server pg_fdw_test
DROP SERVER

Categories

DDL, Foreign Data Wrapper (FDW), SQL command

See also

CREATE SERVER, ALTER SERVER, pg_foreign_server