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

Define a remote PostgreSQL server.

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

Create foreign server

sql
sql
CREATE SERVER analytics_remote
FOREIGN DATA WRAPPER postgres_fdw
OPTIONS (host 'analytics-db', dbname 'analytics', port '5432');
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 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
Drop foreign server
Remove the foreign server and dependent objects.
OpenIn sheetsqlsame section
Show wal_level
Inspect the current WAL level setting.
OpenIn sheetsql