| From: | Dann Corbit <DCorbit(at)connx(dot)com> |
|---|---|
| To: | "'Hu, William'" <HuW(at)trimet(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to select a postgresql table inside Oracle |
| Date: | 2010-11-16 20:35:59 |
| Message-ID: | 87F42982BF2B434F831FCEF4C45FC33E42080833@EXCHANGE.corporate.connx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Hu, William
Sent: Tuesday, November 16, 2010 12:10 PM
To: pgsql-general(at)postgresql(dot)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(at)another_instance(dot)
Are there similar approach without replicate the database tables?
Thanks in advance.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vick Khera | 2010-11-16 20:36:41 | Re: AfterTriggerSaveEvent() called outside of query |
| Previous Message | Pavel Stehule | 2010-11-16 20:28:17 | Re: How to select a postgresql table inside Oracle |