Re: [GENERAL] How to select a postgresql table inside Oracle

2010-11-16 Thread Peter Geoghegan
On 16 November 2010 20:35, Dann Corbit 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 you

Re: [GENERAL] How to select a postgresql table inside Oracle

2010-11-16 Thread Dann Corbit
-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

Re: [GENERAL] How to select a postgresql table inside Oracle

2010-11-16 Thread Pavel Stehule
Hello 2010/11/16 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 > ta...@another_instance. > > > > Are there similar approach without replicate the database tables? > with littl

Re: [GENERAL] How to select a postgresql table inside Oracle

2010-11-16 Thread Peter Geoghegan
On 16 November 2010 20:09, Hu, William 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 > ta...@another_instance. > > > > Are there similar approach without replicate the database tables

[GENERAL] How to select a postgresql table inside Oracle

2010-11-16 Thread 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 ta...@another_instance. Are there similar approach without replicate the database tables? Thanks in advance.