Re: postgresql and oracle, compatibility assessment - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: postgresql and oracle, compatibility assessment
Date
Msg-id 1045494214.1700.2.camel@fuji.krosing.net
Whole thread Raw
In response to postgresql and oracle, compatibility assessment  ("Martin Matusiak" <db@juventuz.net>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: "Martin Matusiak"
Date:
Subject: postgresql and oracle, compatibility assessment
Next
From: Tom Lane
Date:
Subject: Re: Questions about indexes?