Postgresql and Oracle

From: Steve Atkins <steve(at)blighty(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Postgresql and Oracle
Date: 2006-07-16 19:00:05
Message-ID: 4CAE0E3D-A69B-4E86-BC46-280E6BF60978@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Not an advocacy post. If I want advocacy, I know where to find it.

I have an application that uses Postgresql - nothing too fancy, some
plpgsql, a couple of custom types, lots of text and no varchar.

For business reasons I need to also support Oracle. On the app side
this is not a big problem - I'm already using a DB-independent access
library (Qt) and most of my queries are fairly vanilla SQL.

On the database side it's a little more complex. I'm looking for
resources comparing the two, and advice on porting PG -> Oracle
(though I suspect that any docs about Oracle -> PG porting experience
might be useful too). Google finds a bazillion advocacy comparisons,
which makes it hard to find anything more useful.

I already know about OpenACS (a fairly database complex CMS written
for Oracle and ported to Pg) and their docs. If anyone has any other
pointers, they'd be appreciated.

(If it's relevant I'm currently on 7.4, but would be looking at
comparing 8.1 and 10g).

Cheers,
Steve

Browse pgsql-general by date

  From Date Subject
Next Message Brian Mathis 2006-07-16 20:17:13 Re: customizing pg_dump together with copy.c's DoCopy function
Previous Message Ron Johnson 2006-07-16 16:40:15 Re: Scaleable DB structure for counters...