How to select a postgresql table inside Oracle
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.
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
Hello
2010/11/16 Hu, William <HuW@trimet.org>:
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?
with little bit programming yes. There is more ways. Probably the most
simple way is using a dblink
http://archives.postgresql.org/pgsql-hackers/2003-06/msg00361.php
other way, you can use a plperlu and DBI interface
http://www.pgsql.cz/index.php/PL/Perlu_-_Untrusted_Perl_%28en%29
Regards
Pavel Stehule
Show quoted text
Thanks in advance.
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.
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Hu, William
Sent: Tuesday, November 16, 2010 12:10 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to select a postgresql table inside Oracle
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.
On 16 November 2010 20:35, Dann Corbit <DCorbit@connx.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