May 2018
Intermediate to advanced
576 pages
30h 25m
English
In the previous recipe, you saw how to use objects from a different PostgreSQL database, either with dblink or by using the 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 ...