Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Drop foreign server

Remove the foreign server and dependent objects.

Back to sheetBrowse commands
Sign in to save
Section: Foreign Data Wrappers and Cross-DB Access

Drop foreign server

sql
sql
DROP SERVER analytics_remote CASCADE;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Foreign Data Wrappers and Cross-DB Access
Enable postgres_fdw
Install the built-in foreign data wrapper for PostgreSQL servers.
OpenIn sheetsqlsame section
Create foreign server
Define a remote PostgreSQL server.
OpenIn sheetsqlsame section
Create user mapping
Store remote authentication details for one local role.
OpenIn sheetsqlsame section
Import foreign schema
Bring remote tables into a local schema automatically.
OpenIn sheetsqlsame section
Create foreign table manually
Define a foreign table manually.
OpenIn sheetsqlsame section
Show wal_level
Inspect the current WAL level setting.
OpenIn sheetsql