Reading PG data from MySQL stored procedure - Mailing list pgsql-general

From Gauthier, Dave
Subject Reading PG data from MySQL stored procedure
Date
Msg-id 482E80323A35A54498B8B70FF2B8798004D590EE00@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: Reading PG data from MySQL stored procedure  (Merlin Moncure <mmoncure@gmail.com>)
List 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 :-) )

 

 

pgsql-general by date:

Previous
From: Mike Blackwell
Date:
Subject: Cleaning up index names
Next
From: John R Pierce
Date:
Subject: Re: Extraneous Files