Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Import foreign schema

Bring remote tables into a local schema automatically.

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

Import foreign schema

sql
sql
IMPORT FOREIGN SCHEMA public FROM SERVER analytics_remote INTO analytics_fdw;
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
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