Re: Porting from ORACLE to PostgSQL - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Porting from ORACLE to PostgSQL
Date
Msg-id 44FCAEE2.8090903@commandprompt.com
Whole thread Raw
In response to Porting from ORACLE to PostgSQL  (gustavo halperin <ggh.develop@gmail.com>)
List pgsql-general
gustavo halperin wrote:
> Hello
>
> I need to porting many old ORACLE-oriented-SQL files and I have many
> problem with this code. Sometimes the code use some types not supported
> in PosgSQL like "number" or "varchar2", there fore, can I write some
> type of declaration (like in c : #define alias_name name) in order to
> make PosgSQL recognize these types? Or there are other solution that you
> recommend to use ?
>

Look at the orafce project on www.pgfoundry.org. They have ALOT of
Oracle types (over 100).

Sincerely,

Joshua D. Drake


>   Thank you, Gustavo
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: deadlock detected errors
Next
From: Chris Mair
Date:
Subject: Re: Porting from ORACLE to PostgSQL