Re: Oracle to PostgreSQL

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.