Re: Reading PG data from MySQL stored procedure

On Thu, Oct 20, 2011 at 2:22 PM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com> wrote:
> 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.

First question: why in the world can't you do the processing on the
client side? There are gajillion and one data transfer/ETL tools!
mysql of that has pretty much zero server side extensiblity AFAIK.

Of course, it would be quite possible from postgres to query mysql
database, but I digress...

merlin