PostgreSQL and Oracle are both relational databases.
PostgreSQL and Oracle both use a very similar and interesting lock strategy for dealing with sets called MVCC.
PostgreSQL and Oracle can both be accessed in complete a completely generic way using ODBC, OLEDB, JDBC, or a .NET
provider.
PostgreSQL and Oracle can both be accessed by embedded SQL.
PostgreSQL and Oracle both have low level APIs (OCI for Oracle and pqlib for PostgreSQL).
PostgreSQL and Oracle can both be accessed via stored programs written in many different programming languages.
There will be minor differences in the SQL language used to manipulate data.
If the objective of your boss is to create a web server or some other data centric application, then PostgreSQL is
certainlya viable alternative to Oracle.
________________________________________
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Randy Samberg
Sent: Tuesday, March 22, 2005 5:51 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres oracle emulation question
Does anyone know if there is a way in Postgres to emulate Oracle, in other words make Postgres think it is an Oracle
database? If so, do you have any idea what percentage of people are doing this, and how successful they are with this?
Also, how is this done? Do you know of any good links that discuss this. My manager is thinking about replacing a
coupleof Oracle databases with Postgres, and would like to know the answer to this question.
Thanks in advance.
Randy
