Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group