• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (dev)
  • PostgreSQL 14 (beta3)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5 (EOL)

Version charts

Useful overviews

Useful links

DROP 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

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

Categories

See also