How to select a postgresql table inside Oracle

From: "Hu, William" <HuW(at)trimet(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to select a postgresql table inside Oracle
Date: 2010-11-16 20:09:31
Message-ID: 319F19C1AA97814BABB4E537722B36E4AE61E9@csmail5.tri-met.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I have a need to select some data in a Oracle database from a
Postgresql table. I know how to do this among Oracle instances, eg.
Select * from table(at)another_instance(dot)

Are there similar approach without replicate the database tables?

Thanks in advance.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2010-11-16 20:16:13 Re: ipv4 data type does not allow to use % assubnet mask delimiter
Previous Message Richard Broersma 2010-11-16 19:49:01 Re: Counting boolean values (how many true, how many false)