Re: How to select a postgresql table inside Oracle

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

On 16 November 2010 20:35, Dann Corbit <DCorbit(at)connx(dot)com> wrote:
> Oracle from PostgreSQL:
>
> http://www.sqlmag.com/article/sql-server/setting-up-an-oracle-linked-server49687.aspx
>
>
>
> PostgreSQL from Oracle:
>
> http://www.postgresql.org/docs/current/static/dblink.html
>
>
>
> Or perhaps I do not understand your question.
>

Uh, no, dblink is for connecting to a PostgreSQL database from within
another. You want dbi-link.

--
Regards,
Peter Geoghegan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2010-11-16 20:53:37 Re: median for postgresql 8.3
Previous Message Tom Lane 2010-11-16 20:38:51 Re: ipv4 data type does not allow to use % assubnet mask delimiter