Re: odbc to emulate mysql for end programs

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: odbc to emulate mysql for end programs
Date: 2015-06-01 22:52:01
Message-ID: 556CE211.7060901@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-06-02 00:44:31 Re: pl/python composite type array as input parameter
Previous Message William Dunn 2015-06-01 22:25:10 Re: odbc to emulate mysql for end programs