DROP SERVER

A DDL 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

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)

See also

CREATE SERVER, ALTER SERVER, pg_foreign_server