Conference Schedule - PGCon 2023

Writing a Foreign Data Wrapper

Date: 2023-06-01
Time: 10:00–10:45
Room: DMS 1140
Level: Intermediate

A foreign data wrapper (FDW) is a PostgreSQL extension that allows other data sources, including non-relational ones, to be queried from within a PostgreSQL database just like other tables. An FDW can range from the very simple (only basic SELECT statements) to very sophisticated (sending predicates, aggregates, and joins down to the remote server).

This talk is an introduction to implementing a foreign data wrapper. We'll discuss the basics of an FDW, debugging, and how to implement more sophisticated features. A basic knowledge of C is helpful, but an FDW is an excellent first PostgreSQL extension project.

link to video


Christophe Pettus