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-ow...@postgresql.org [mailto:pgsql-general-ow...@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 ta...@another_instance. Are there similar approach without replicate the database tables? Thanks in advance.
