Re: Oracle to PostgreSQL

John R Pierce wrote on 16.03.2009 00:41:
> Greenhorn wrote:
>> Unfortunately When I execute the above files using \i I am getting
>> errors like
>>
>> ERROR:  syntax error at or near "("
>> LINE 4:   SUB_TYPE          NUMBER(3)                   NOT NULL,
>>
>> Obviously 'number' is not PostgreSQL data type so is 'varchar2'.  What
>> is your suggestion to create these tables in PostgreSQL?  Should I
>> pre-process using Sed/Awk to find/replace the field type first?  Any
>> recommendation is greatly appreciated :)
>>
>
> change number to numeric, and varchar2 to char and you'll likely be good.
>
>
>
My guess would have been that varchar is the equivalent to varchar2

char does a blank padding and is different in behaviour to varchar (as it is in
Oracle)

Thomas