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?