Re: [SQL] How to write query to access another odbc source

2011-10-19 Thread Rich
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 chan

Re: [SQL] How to write query to access another odbc source

2011-10-19 Thread pasman pasmański
Hi. If you have 9.1, then exist foreign wrapper odbc_fdw, you may try it. 2011/10/19, Rich : >> >> 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? >

Re: [SQL] How to write query to access another odbc source

2011-10-19 Thread Scott Marlowe
On Wed, Oct 19, 2011 at 9:19 AM, Rich 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

[SQL] How to write query to access another odbc source

2011-10-19 Thread Rich
> > 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? >