Reading PG data from MySQL stored procedure

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Reading PG data from MySQL stored procedure
Date: 2011-10-20 19:22:07
Message-ID: 482E80323A35A54498B8B70FF2B8798004D590EE00@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here's a real long shot, but what the heck...

I have a user that's using a system that gives him a single MySQL DB handle to work with. He must get all his data through this handle. He wants some of my PG based data. Not only can't he open a new DB handle to my PG DB, but he cannot even run something at the system level (otherwise I'd just give him a "psql -P pager=off <db> -c "select foo from bar" "). So it has to come "through" MySQL somehow, MySQL V5.1 no less.

It appears that they have some sort of external language capability for stored procedures in their V6. And they have something else which'll run an external object (UDF something or other). But what I'm throwing out there is a question regarding any known data interchange functionality that might exist between these 2 different SQL DB engines.

As I said, a real long shot.

Thanks for any comments (even if it's NO :-) )

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-10-20 19:24:40 Re: Extraneous Files
Previous Message John R Pierce 2011-10-20 19:21:47 Re: a set of key/value pairs