Unlocking Proprietary Data with PostgreSQL Foreign Data Wrappers

A session at OSCON 2012

Thursday 19th July, 2012

5:00pm to 5:40pm (PST)

PostgreSQL 9.1 introduced ‘Foreign Data Wrappers’ (FDW) – a partial implementation of the SQL/MED standard for handling access to remote data sources. FDW allows PostgreSQL to expose remote data as foreign tables which then behave similarly to native PostgreSQL tables, in particular, allowing remote data to be queried with SQL statements.

This session provides an overview of Foreign Data Wrappers, looks at the native interface for writing FDWs in C, and contrasts this with Multicorn, an open source framework that allows FDWs to be developed in Python. We will show a real-world Python FDW that retrieves business data from salesforce.com, with a sample client application that demonstrates how foreign data can be combined with data held in native PostgreSQL tables using a simple SQL JOIN.

About the speaker

This person is speaking at this event.
Pat Patterson


Pat Patterson at previous events

Coverage of this session

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 5:00pm5:40pm PST

Date Thu 19th July 2012


Portland 252, Oregon Convention Center

Short URL


View the schedule



See something wrong?

Report an issue with this session