Tried both, but they don't work for 9.1. I want to thank Adrian, without his help I would never find the link that confirmed the postgresql_fdw is not working.
Would be nice to make all this information clear in Foreign Data Wrapper documentation at PostgreSQL manuals. I wasted at least 12 hours trying to make it work. The only real option is file_fdw, that is not that useful (I would connect my database to files just for curiosity - otherwise, I would use only an application that validates the file before importing into database for fast operations). odbc_fdw would work, but it's near to impossible for a normal human bean to compile using MSVC; and it's not available in binary format (see, I'm not a C developer for many, many years now... and I work in an hybrid environment with Windows and Linux machines). Sorry for the rant... I hope to save time for others who wish to use FDW in a real scenario. Regards, Edson Richter. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
