Thread: Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?
Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?
From
Stefan Keller
Date:
Hi, I'm interested in using Foreign Data Wrappers (FDW) in order to connect PG to CSV files, MongoDB, MS SQL Server and the Web. Was anyone able to compile and use FDWs [1], like mysql_fdw, odbc_fdw or www_fdw, in PG 9.1.1 (besides official file_fdw) under Ubuntu but also Windows? Does anyone have experience, especially with odbc_fdw (e.g. performance) ? Yours, Stefan [1] http://wiki.postgresql.org/wiki/Foreign_data_wrappers
Re: Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?
From
Ronan Dunklau
Date:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello. We use (and develop) the multicorn foreign data wrapper (http://multicorn.org). It is very experimental, but works well for our needs. We use it to perform IMAP searches in our in-house CRM solution, as well as to list files on a file system. We never tested it under Windows so try it at your own risks :) - -- Ronan Dunklau -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) iQEcBAEBAgAGBQJO1MrHAAoJECTYLCgFy323X6IH/Avo7KERwWORjl543QvFnwHs nueyj7m/LUjjBbl/WjtrrRFRFnC1Y2iO4gvJRqVe119KRJBvyxiLqF0mr40U0lWg EGErRf4648xoRL/gCvYHJmovs/ukarBk202v4TJPb9XThZgjlc4oSKa9qNUOj2OF xONIO/SnnZ2Cql/MWcEQuuSjZ/ET+6tBNawCA474h19KX+i09OTcAvNLC9pmVhOt t5j8U1bDDKS+JJ5SghSlR5Za5RE9XkA/j2VSLULtz4dV0RF3s+P0NFDYJfxVfVCw arzAfIbT44hjBF9esIJXiI5jhteQ83C+zezCUixes2G6NrzFJu4fFaeR7H77cOo= =iopq -----END PGP SIGNATURE-----