| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Hu, William" <HuW(at)trimet(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to select a postgresql table inside Oracle |
| Date: | 2010-11-16 20:28:17 |
| Message-ID: | AANLkTi=FnwEX80f_mcZGB1D9j28BCH-3zdnriuLEm1sW@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
2010/11/16 Hu, William <HuW(at)trimet(dot)org>:
> 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?
>
with little bit programming yes. There is more ways. Probably the most
simple way is using a dblink
http://archives.postgresql.org/pgsql-hackers/2003-06/msg00361.php
other way, you can use a plperlu and DBI interface
http://www.pgsql.cz/index.php/PL/Perlu_-_Untrusted_Perl_%28en%29
Regards
Pavel Stehule
>
>
> Thanks in advance.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2010-11-16 20:35:59 | Re: How to select a postgresql table inside Oracle |
| Previous Message | Peter Geoghegan | 2010-11-16 20:27:06 | Re: How to select a postgresql table inside Oracle |