Thread: How to write query to access another odbc source

<blockquote class="gmail_quote" style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex">I
havea mumps database with an ODBC connection so I can write queries from this database.  How can I write a sql in
Postgresqlto access this database to use in my Postgresql reports?<br /></blockquote><br /> 

On Wed, Oct 19, 2011 at 9:19 AM, Rich <rhdyes@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.

Hi.

If you have 9.1, then exist foreign wrapper odbc_fdw, you may try it.

2011/10/19, Rich <rhdyes@gmail.com>:
>>
>> 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?
>>
>


-- 
------------
pasman

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.