Accessing objects in other foreign databases
In the previous recipe, you saw how to use objects from a different PostgreSQL database, either with dblink or by using the newer Foreign Data Wrapper infrastructure. Here we will explore another variant of the latter—using Foreign Data Wrappers to access databases other than PostgreSQL.
There are many Foreign Data Wrappers for other database systems, all of which are maintained as extensions independently from the PostgreSQL project. PGXN, the PostgreSQL Extension Network mentioned in Chapter 3, Configuration, is a good place where you can see which extensions are available.
Just note this so that you don't get confused: while you can find Foreign Data Wrappers to access several database systems, there ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
