Search Postgresql Archives

Reading PG data from MySQL stored procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 :-) )

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux