Re: DBLINK - PostgreSQL to ORACLE

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Ferrell, Denise CTR NSWCDD, Z11 *EXTERN*" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: DBLINK - PostgreSQL to ORACLE
Date: 2014-10-27 10:41:49
Message-ID: A737B7A37273E048B164557ADEF4A58B17D7BB7B@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Denise Ferrell wrote:
> Using PostgreSQL 9.3.4 on Linux Red-Hat platform.
>
> Is there a way to use dblink to link from a PostgreSQL database to an Oracle database?

No, dblink can only connect to PostgreSQL.

Try oracle_fdw: http://laurenz.github.io/oracle_fdw/

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2014-10-29 13:18:47 A local replication entry
Previous Message liuyuanyuan 2014-10-27 08:05:53 potential invalid input field of pgAdmin New Column GUI