Re: How to write query to access another odbc source

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Rich <rhdyes(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to write query to access another odbc source
Date: 2011-10-19 15:47:55
Message-ID: CAOR=d=2araJ=asy7tk3hCpmPonUbBCfvWzfbwUpvqxPQ5SSKCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message pasman pasmański 2011-10-19 17:53:56 Re: How to write query to access another odbc source
Previous Message Rich 2011-10-19 15:19:53 How to write query to access another odbc source