Re: postgresql and oracle, compatibility assessment

Would it be possible to create some sort of transparent API based on ODBC to
be used with PostgreSQL and Oracle? I know there exists a JDBC - ODBC bridge
for java.


Martin

----- Original Message -----
From: "Hannu Krosing" <hannu@tm.ee>
To: "Martin Matusiak" <db@juventuz.net>
Cc: <pgsql-hackers@postgresql.org>
Sent: Monday, February 17, 2003 4:03 PM
Subject: Re: [HACKERS] postgresql and oracle, compatibility assessment


> Martin Matusiak kirjutas E, 17.02.2003 kell 16:53:
> > Greetings,
> >
> > I am doing a project for college developing a java system utilizing a
> > RDBMS. The choice is between PostgreSQL and Oracle and I'm wondering
> > exactly how impossible would it be to make it compatible with both.
> > Postgre is said to be completely ANSI SQL complaint,
>
> PostgreSQL is *much* more ANSI comliant than Oracle.
>
> > is it feasible to imagine one could run dumps from Postgre into Oracle
> > and vice versa?
>
> Not all data types are named the same (Oracles varchar is varchar2,
> etc.)
>
> > Alternatively, run separate queries on both to set the structure and
> > relations, then transfer only data?
>
> Much more likely to succeed.
>
> You may be interested in OpenACS ( http://openacs.org/ ) project, which
> runs on both Oracle and PostgreSQL.
>
> ---------
> Hannu
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>