I have a little schema in pgsql and some annotation in mysql; either
way transfer of schema might result in data types etc conflicts. So if
i could make these two talk then i don't have to worry about schema
transfer. So the question and frankly i thought it was crazy thought!
The replys so far indicate that i am not looney at all ;)
Hrishi
On 5/26/05, Dawid Kuroczko <qnex42@gmail.com> wrote:
> 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?
>