Re: How to select a postgresql table inside Oracle

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: "Hu, William" <HuW(at)trimet(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to select a postgresql table inside Oracle
Date: 2010-11-16 20:27:06
Message-ID: AANLkTikVDf3DsorFDk5epgh1VCbYYihb2WUCqr4wyEdp@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 16 November 2010 20:09, Hu, William <HuW(at)trimet(dot)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(at)another_instance(dot)
>
>
>
> Are there similar approach without replicate the database tables?
>
>
>
> Thanks in advance.

Yes. Look at dbi-link.

--
Regards,
Peter Geoghegan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-11-16 20:28:17 Re: How to select a postgresql table inside Oracle
Previous Message Peter Eisentraut 2010-11-16 20:16:13 Re: ipv4 data type does not allow to use % assubnet mask delimiter