Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres stored proc that extracts data from Oracle - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Postgres stored proc that extracts data from Oracle
Date
Msg-id 20050314044816.GB30090@wolff.to
Whole thread Raw
In response to Postgres stored proc that extracts data from Oracle  (James <jamesfuerte@yahoo.com>)
List pgsql-general
Tree view 
On Thu, Mar 10, 2005 at 17:12:46 -0800,
  James <jamesfuerte@yahoo.com> wrote:
>
> Do you guys have thoughts on how to implement this? I
> am not expecting an easy solution but I wish to get
> started asap. Any advice would be appreciated.

My usual solution is to use a perl script which talks to both databases.

The dblink module in postgres might also be useful to you.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Oracle's Virtual Private Database functionality
Next
From: George Essig
Date:
Subject: Re: sql question