Foreign data wrappers
From PostgreSQL wiki
Contents |
Foreign Data Wrappers
In 2003, a new extension called SQL/MED ( "SQL Management of External Data" ) was added to the SQL standard. It is a standardized way of handling access to remote objects in SQL databases. In 2011, PostgreSQL 9.1 was released with a great support of this standard.
In a nutshell, you can now use various Foreign Data Wrappers (FDW) to connect a PostgreSQL Server to remote data stores. This page is an incomplete list of the Wrappers available right now. Another fdw list can be found at the PGXN website : http://pgxn.org/tag/fdw/
Please keep in mind that most of these wrappers are not officially supported by the PostgreSQL Global Development Group (PGDG) and that some of these projects are still in Beta version. Use Carefully !
SQL Databases Wrappers
oracle_fdw :
- source code : http://pgfoundry.org/projects/oracle-fdw/
- install with PGXN : http://pgxn.org/dist/oracle_fdw/
mysql_fdw : This extension implements a Foreign Data Wrapper for MySQL. It is supported on PostgreSQL 9.1 and above.
- source code : http://github.com/dpage/mysql_fdw
- install with PGXN : http://pgxn.org/dist/mysql_fdw/
odbc_fdw is wrapper for databases with an ODBC driver, including Oracle, DB2, Microsoft SQL Server, Sybase, Pervasive SQL, IBM Lotus Domino, MySQL, PostgreSQL and desktop database products such as FileMaker and Microsoft Access :
- source code : https://github.com/ZhengYang/odbc_fdw
- install with PGXN : http://pgxn.org/dist/odbc_fdw/
NoSQL Databases Wrappers
couchdb_fdw is a wrapper for CouchDB
- source code : https://github.com/ZhengYang/couchdb_fdw
- install with PGXN : http://pgxn.org/dist/couchdb_fdw/
redis_fdw is a wrapper for Redis
- source code : https://github.com/dpage/redis_fdw
- install with PGXN : http://pgxn.org/dist/redis_fdw/
File Wrappers
file_fdw is a CSV Files wrapper. It is a delivered as an official extension of PostgreSQL 9.1
- documentation : http://www.postgresql.org/docs/9.1/static/file-fdw.html
- example : http://www.depesz.com/index.php/2011/03/14/waiting-for-9-1-foreign-data-wrapper/
file_text_array_fdw is another CSV wrapper :
- source code : https://github.com/adunstan/file_text_array_fdw
Others
twitter_fdw is a wrapper which fetches text messages from Twitter over the Internet and returns as a table :
- source code : https://github.com/umitanuki/twitter_fdw
- install with PGXN : http://pgxn.org/dist/twitter_fdw/
ldap_fdw allows your PostgreSQL server to query an LDAP server and retrieve data from some pre-configured Organizational Unit
- source code : https://github.com/guedes/ldap_fdw
- install with PGXN : http://pgxn.org/dist/ldap_fdw/
s3_fdw reads files located in Amazon S3
- source code : https://github.com/umitanuki/s3_fdw
- install with PGXN : http://pgxn.org/dist/s3_fdw/
