Thread: 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 > > > 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