DBLINK - PostgreSQL to ORACLE

From: "Ferrell, Denise CTR NSWCDD, Z11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: DBLINK - PostgreSQL to ORACLE
Date: 2014-10-20 18:43:07
Message-ID: 2BC18916DE4BF141AC1EFC55CE2CAE7D5939F0@NAEANRFKXM01V.nadsusea.nads.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Tried the following and it's returning a SQL state: 08001

SELECT * from dblink('host=<hostname> dbname=<database> port=1521 user=<username> password=<password>',
'select column1,
Column2,
Column3
FROM <schema.table>') as t1 (column1 name, column2 . . .);

Thank you in advance.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message desmodemone 2014-10-20 18:50:54 Re: DBLINK - PostgreSQL to ORACLE
Previous Message Borys Gogulski 2014-10-20 09:24:48 PostgreSQL 9.3 - pg_stat_database - tup_returned got "too high" value