I have references to dblink. I just installed 9.1.1.1 on windows server 2008 R2 and did a search on the file dblink.sql and cannot find it. I used the one click installer from enterprisedb.
1. Where is the dblink.sql file or does it not exist anymore and the integration into postgresql has changed. 2. I cannot find any examples of connecting to another database engine through odbc. Is there any of those. On Wed, Oct 19, 2011 at 11:47 AM, Scott Marlowe <scott.marl...@gmail.com>wrote: > On Wed, Oct 19, 2011 at 9:19 AM, Rich <rhd...@gmail.com> wrote: > >> I have a mumps database with an ODBC connection so I can write queries > >> from this database. How can I write a sql in Postgresql to access this > >> database to use in my Postgresql reports? > > dblink lets one pg server access another via SQL, dbilink lets one pg > server access any other db server via SQL. Not sure if dbilink is > maintained or not. >