A look at the new SQL/MED features in PostgreSQL 9.1 and how they can be used to connect PostgreSQL to any data source.

In this talk I will discuss the new SQL/MED features in PostgreSQL 9.1. We will examine how PostgreSQL can interface with external data sources, including files, web services, and both relational and non-relational databases, and how we may use that ability to our advantage.

Finally, we will review the code behind a simple Foreign Data Wrapper to another database to see how easy it can be to add support for new data sources with just a little C programming experience.

PostgreSQL at the centre of your dataverse A look at the new SQL/MED features in PostgreSQL 9.1 and how they can be used to connect PostgreSQL to any data source. In this talk I will discuss the new SQL/MED features in PostgreSQL 9.1. We will examine how PostgreSQL can interface with external data sources, including files, web services, and both relational and non-relational databases, and how we may use that ability to our advantage. Finally, we will review the code behind a simple Foreign Data Wrapper to another database to see how easy it can be to add support for new data sources with just a little C programming experience. Presented at PG Open 2011, Chicago.