Re: odbc to emulate mysql for end programs - Mailing list pgsql-general

From John R Pierce
Subject Re: odbc to emulate mysql for end programs
Date
Msg-id 556CE211.7060901@hogranch.com
Whole thread Raw
In response to odbc to emulate mysql for end programs  (Mimiko <vbvbrj@gmail.com>)
List pgsql-general
On 6/1/2015 12:04 PM, Mimiko wrote:
> I have several programs which can use mysql,access,oracle DB as a
> front-end DB via odbc. Is there a method to emulate or hide the
> back-end DB so for program it will be seen as mysql, but real DB will
> be on postgres?


ODBC *is* that method.   you just need a database specific ODBC driver,
which William already described.

now, if your code is making use of MySQL specific features, then its not
going to work with Postgres (but it also likely won't work with Oracle
or Access/Jet databases either).



--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: William Dunn
Date:
Subject: Re: odbc to emulate mysql for end programs
Next
From: Adrian Klaver
Date:
Subject: Re: pl/python composite type array as input parameter