Converting PL/SQL to PL/PGSQL - Mailing list pgsql-hackers

From Klaus Reger
Subject Converting PL/SQL to PL/PGSQL
Date
Msg-id 200105091024.f49AOpZ12758@pc01.reger-clan.de
Whole thread Raw
Responses Re: Converting PL/SQL to PL/PGSQL  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgsql-hackers
Hi all!

I have to convert functions and procedures from Oracle to PostgreSQL. I 
looked at all the stuff of the Pg-Homepage and I ask me if there are any 
tools, that support the conversion. 

Writing PS/PGSQL tools seems to be a bit hard, because of the existing 
tool-infrastructure on linux. Are there are tools I have overseen?

I have implemented the following tools for my use yet:

- A WWWdb-Application for editing and testing of SQL-Procedures over a WEB-frontend
- A perl-script, that does basic conversions between PL/SQL <-> XML <-> PL/PGSQL (The Procedure-definition is converted
completely,the code-block a little bit)
 

Who else is working in this area? Any tips?

Regards, Klaus

Visit WWWdb at
http://wwwdb.org


pgsql-hackers by date:

Previous
From: 施銘斌
Date:
Subject: Can PostgreSQL's Stored Procedure return a ReccordSet?
Next
From: "Mark L. Woodward"
Date:
Subject: Re: File system performance and pg_xlog