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.
- PostgreSQL 8.4
- added (commit cae565e5)
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
References
- PostgreSQL documentation: DROP SERVER