Reading PG data from MySQL stored procedure

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема Reading PG data from MySQL stored procedure
Дата
Msg-id 482E80323A35A54498B8B70FF2B8798004D590EE00@azsmsx504.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: Reading PG data from MySQL stored procedure
Список 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 по дате отправления:

Предыдущее
От: Mike Blackwell
Дата:
Сообщение: Cleaning up index names
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Extraneous Files