Thread: how to port Oracle database to PostgreSQL?

Thanks for your reply, however as I am a total newbie around here, I've
no clue how to get to postgresql-x.y.z/contrib. I looked on the main
page but couldn't find it.

-----Original Message-----
From: Scott Marlowe [mailto:smarlowe@qwest.net]
Sent: Saturday, October 23, 2004 7:10 PM
To: Vassilev, Lubomir G.
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to port Oracle database to PostgreSQL?

On Wed, 2004-10-20 at 13:47, Vassilev, Lubomir G. wrote:
> ok, this is what's going on. i have this VB.NET application with
> Oracle 8.1.7 back end, but now i have to switch the whole thing to
> PostgreSQL. how do i do that? it's a big database, about 135 tables, a
> lot of views, triggers, a few stored procedures and functions. i
> understand there is some tool to do that.

There's a directory under postgresql-x.y.z/contrib called oracle that
has some helpful scripts.

On Mon, 2004-10-25 at 09:16 -0500, Vassilev, Lubomir G. wrote:
> Thanks for your reply, however as I am a total newbie around here, I've
> no clue how to get to postgresql-x.y.z/contrib. I looked on the main
> page but couldn't find it.

It is part of the tarball that you download (if you download the
source).

--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
     "Only take heed to thyself, and keep thy soul
      diligently, lest thou forget the things which thine
      eyes have seen, and lest they depart from thy heart
      all the days of thy life; but teach them to thy sons,
      and to thy sons' sons..."        Deuteronomy 4:9