From: | Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> |
---|---|
To: | Dawid Kuroczko <qnex42(at)gmail(dot)com> |
Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Just a crazy idea! |
Date: | 2005-05-26 21:21:02 |
Message-ID: | 829d7fb60505261421128f9ffd@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com> wrote:
> On 5/26/05, Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)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?
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Parker | 2005-05-26 21:25:06 | Re: another failover testing question |
Previous Message | Dawid Kuroczko | 2005-05-26 21:17:46 | Re: Just a crazy idea! |