Postgres Pro
Downloads
Home   >   mailing lists

Re: How to select a postgresql table inside Oracle - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: How to select a postgresql table inside Oracle
Date
Msg-id AANLkTikVDf3DsorFDk5epgh1VCbYYihb2WUCqr4wyEdp@mail.gmail.com
Whole thread Raw
In response to How to select a postgresql table inside Oracle  ("Hu, William" <HuW@trimet.org>)
List pgsql-general
Tree view 
On 16 November 2010 20:09, Hu, William <HuW@trimet.org> wrote:
> 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@another_instance.
>
>
>
> Are there similar approach without replicate the database tables?
>
>
>
> Thanks in advance.

Yes. Look at dbi-link.

--
Regards,
Peter Geoghegan

pgsql-general by date:

Previous
From: "Hu, William"
Date:
Subject: How to select a postgresql table inside Oracle
Next
From: Pavel Stehule
Date:
Subject: Re: How to select a postgresql table inside Oracle