Postgres Pro
Downloads
Home   >   mailing lists

Re: How to write query to access another odbc source - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: How to write query to access another odbc source
Date
Msg-id CAOR=d=2araJ=asy7tk3hCpmPonUbBCfvWzfbwUpvqxPQ5SSKCg@mail.gmail.com
Whole thread Raw
In response to How to write query to access another odbc source  (Rich <rhdyes@gmail.com>)
Responses Re: How to write query to access another odbc source  (Rich <rhdyes@gmail.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Rich
Date:
Subject: How to write query to access another odbc source
Next
From: pasman pasmański
Date:
Subject: Re: How to write query to access another odbc source