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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]
On Behalf Of Hu, William 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. |