Postgres Pro
Downloads
Home   >   mailing lists

Oracle to Postgress Migration - Mailing list pgsql-general

From DAVID ROTH
Subject Oracle to Postgress Migration
Date
Msg-id 620574116.118124.1657825618304@connect.xfinity.com
Whole thread Raw
In response to Re: Get the table creation DDL  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Oracle to Postgress Migration  (Bruce Momjian <bruce@momjian.us>)
Re: Oracle to Postgress Migration  ("Gogala, Mladen" <gogala.mladen@gmail.com>)
List pgsql-general
Tree view 
Has anything been published on Oracle to Postgress migration.

I am finding plenty of information about schema migration but,
I think this is the easy part.
I have a a tremendous amount of SQL and PL/SQL code that needs to be translated.  I know Oracle "packages" will not
translate. DECODE is not standard and will need to be rewritten as CASE.  I have seen feature/function translation
matricesto/from Oracle and other database but I can't seem to find one for Postgress.
 
Please point me in the right direction.
Dave

pgsql-general by date:

Previous
From: Frank Streitzig
Date:
Subject: Re: first order by then partition by x < a fixed value.
Next
From: Bruce Momjian
Date:
Subject: Re: Oracle to Postgress Migration