Postgres Pro
Downloads
Home   >   mailing lists

Re: How to select a postgresql table inside Oracle - Mailing list pgsql-general

From Dann Corbit
Subject Re: How to select a postgresql table inside Oracle
Date
Msg-id 87F42982BF2B434F831FCEF4C45FC33E42080833@EXCHANGE.corporate.connx.com
Whole thread Raw
In response to How to select a postgresql table inside Oracle  ("Hu, William" <HuW@trimet.org>)
Responses Re: How to select a postgresql table inside Oracle  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
List pgsql-general
Tree view

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@postgresql.org [mailto:pgsql-general-owner@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 table@another_instance.

 

Are there similar approach without replicate the database tables?

 

Thanks in advance.

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: How to select a postgresql table inside Oracle
Next
From: Tom Lane
Date:
Subject: Re: ipv4 data type does not allow to use % assubnet mask delimiter