IntermediateAdvanced PostgreSQL
Theory: Foreign Data Wrappers (FDW)
The query
SQL
-- Q: What are Foreign Data Wrappers?
-- A: FDWs allow PostgreSQL to act as a federated database.
-- You can query data residing in external systems (like another PostgreSQL server,
-- MySQL, MongoDB, Redis, or even CSV files) using standard SQL as if the tables
-- lived locally in your database.Note
“Implemented via CREATE SERVER and CREATE FOREIGN TABLE.