The software system they are being forced to use gives them the ability to send queries to a MySQL which has already been connected to. However, they do have the authority to add things to that DB, like stored procedures. This user isn't coding anything per-se, they're just using the interface provided. But they can "call" a stored procedure/function because that's ligit sql. The data that flows from that goes into other parts of the system for reporting, etc... . -----Original Message----- From: Merlin Moncure [mailto:mmoncure@xxxxxxxxx] Sent: Thursday, October 20, 2011 3:33 PM To: Gauthier, Dave Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Reading PG data from MySQL stored procedure On Thu, Oct 20, 2011 at 2:22 PM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
