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
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: [email protected] [mailto:pgsql-g

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