Foreign data wrappers

lastmod 2026-02-28created 2026-02-276 edits

A foreign table is used when data in an external DB needs to be linked in real time

A foreign table uses the FDW (foreign-data wrapper) approach and offers better performance than DBLink

Categories

• postgres_fdw - foreign-data wrapper for PostgreSQL
• mysql_fdw - foreign-data wrapper for MySQL

See also

• postgres

Favorite site

• Postgres Wrappers - Wrappers
• Foreign data wrappers - PostgreSQL wiki
• Foreign Data Wrappers | Supabase Docs