Postgres 2 MSSQL database link
Postgres foreign data wrapper for MSSQL database
Introduction
This is a continuation of #fdw foreign data wrappers series of posts. In this post we will deal with MSSQL database access from within Postgres.
FDW¶
Postgres 2 MongoDB database link
Postgres foreign data wrapper for MongoDB database
This is part 4 of #fdw foreign data wrappers series of posts. Earlier we have introduced wrappers for mysql, oracle and sqlite databases. In this post we will connect to MongoDB database from within Postgres.
Postgres 2 SQLite database link
Postgres foreign data wrapper for SQLite database
Introduction
This is part 3 of #fdw foreign data wrappers series of posts. Initial part 1 was about connectivity to MySQL database. Next part 2 was related to accessing Oracle database. In this post we will access SQLite database from within Postgres.
Postgres 2 Oracle database link
Postgres foreign data wrapper for Oracle database
Introduction
This is part 2 of #fdw foreign data wrappers series of posts. In part 1 it was described what foreign data mean in Postgres as well as provided an example of connection to MySQL database. In this post we will deal with accessing data in Oracle database.
Postgres 2 MySQL database link
Postgres foreign data wrapper for MySQL database
Foreign data access
This is the first part of #fdw foreign data wrappers series of posts.
One of the great features in Postgres is the ability to access data stored in outer sources as if they were stored in ordinary tables within the database. There is no requirement to the source as is. For example, it can be another RDBMS such as Oracle or MySQL. But we are not limited to relational databases only. It can be also just a csv file or even Hadoop file system objects. All you need to do to get access to these data is to install corresponding foreing data wrapper extension.