oracle 9i to postgres 7.4.5 - Mailing list pgsql-novice

From Antoine
Subject oracle 9i to postgres 7.4.5
Date
Msg-id 92d3a49504092013355dd7e69e@mail.gmail.com
Whole thread Raw
Responses Re: oracle 9i to postgres 7.4.5
List pgsql-novice
Hi
I would like to try and export the db at work (oracle 9i) and use it
at home with postgres. I am still a complete noob with both (pretty
much with db admin actually...), and the web doesn't turn up much that
looks that promising... Can people who have done this sort of thing
before either suggest some links that have decent info or give me
reasonably explicit instructions (;-))? The oracle db is quite weildy
(lots of tables but bugger all data) but I don't think it has much by
way of triggers or functions, in any case the apps we are developing
work with an access export, so there can't be that many. It is a bit
of a monster really...
Next question - they have set up all the actual data tables in access
- and the access exports are done that way. I have found a script to
convert from access to postgres, is just using this (seeing as the
non-access stuff is not that important, for the moment anyway) going
to be *much* easier?
Cheers
Antoine

--
G System, The Evolving GUniverse - http://www.g-system.at

pgsql-novice by date:

Previous
From: derrick@grifflink.com
Date:
Subject: Return Value on UPDATE trigger
Next
From: Tom Lane
Date:
Subject: Re: oracle 9i to postgres 7.4.5