Re: Just a crazy idea!

On 5/26/05, Hrishikesh Deshmukh <hdeshmuk@gmail.com> wrote:
> Is it possible to connect a DB in Postgresql to a DB in MySQL!
> I know its a crazy idea!

Why, of course.  Been' doing that.

All you need is to write a set of functios, for example in PL/perlU,
some of them being set returning functions.

For my purposes I did a function which connects to mysql to
call its encrypt function, and a function which returns "show databases"
and similar stuff.

Basically -- yes you can do it, though things getting tricky if you want
to have _read_ access to _big_ tables. :)

   Regards,
      Dawid

PS: For the reference, why do you need to connect to mysql?