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 ;)
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. :)
> PS: For the reference, why do you need to connect to mysql?
In response to
pgsql-general by date
|Next:||From: David Parker||Date: 2005-05-26 21:25:06|
|Subject: Re: another failover testing question |
|Previous:||From: Dawid Kuroczko||Date: 2005-05-26 21:17:46|
|Subject: Re: Just a crazy idea!|