Re: [SQL] is there a mysql to postgresql sql converter?

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: Clay <DrFrog(at)smartt(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] is there a mysql to postgresql sql converter?
Date: 2000-02-15 12:17:37
Message-ID: Pine.GSO.4.02A.10002151314490.28210-100000@Krokodil.DoCS.UU.SE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 14 Feb 2000, Clay wrote:

> if so id like to see it/have it!
>
> if not is anyone interested in helping to make a script of some sort?

In all generality, this is a rather complex issue: converting the database
schemas (removing non-standard datatypes, such as enum), converting the
queries, plus converting the C code. As I understand it, their C API uses
some sort of "fetch next row" function, whereas we have a "get nth row"
call. So you'd also have to change the program logic. And that covers only
C, of course. Probably won't happen too soon.

--
Peter Eisentraut Sernanders vaeg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Kresse 2000-02-15 15:01:34 Re: [SQL] "Permission denied" on public view
Previous Message Clay 2000-02-15 00:31:48 is there a mysql to postgresql sql converter?