| From: | Dawid Kuroczko <qnex42(at)gmail(dot)com> |
|---|---|
| To: | Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> |
| Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Just a crazy idea! |
| Date: | 2005-05-26 21:17:46 |
| Message-ID: | 758d5e7f050526141736b92aa7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Hrishikesh Deshmukh | 2005-05-26 21:21:02 | Re: Just a crazy idea! |
| Previous Message | Hrishikesh Deshmukh | 2005-05-26 21:15:59 | Re: Just a crazy idea! |