From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | ted(at)3shmoos(dot)ca |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Live Link to Oracle? |
Date: | 2003-04-08 23:34:50 |
Message-ID: | 20030408233449.GC15928@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 08, 2003 at 08:37:16AM -0400, Ted Taylor wrote:
> I'd like to set up a pgsql database that has server-based links back to
> an Oracle db. Not replication, but a live link (the data I'm looking
> for can change rapidly). The pgsql client would see it as a native
> pgsql table, but the pgsql server would submit the query to Oracle in
> real-time. Basically, a view of the Oracle data.
There is a dblink in in the postgres source that does this between seperate
postgres servers. Perhaps just altering this to deal if oracle servers
instead would be possible?
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
> - Samuel P. Huntington
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2003-04-08 23:46:23 | Re: Yet Another (Simple) Case of Index not used |
Previous Message | Martijn van Oosterhout | 2003-04-08 23:24:48 | Re: extracting time from a timestamp with time zone field |