Thread: Datatype Definition

Datatype Definition

From
"Vincenzo Alberico"
Date:
How can I define a synonym datatype called number for the default datatype
numeric?
I've this problem because I want to convert Oracle DB schemas to postgresql,
and I would like not to convert all my script for generating the db.
TIA
Vinz



Re: Datatype Definition

From
"scott.marlowe"
Date:
On Mon, 12 May 2003, Vincenzo Alberico wrote:

> How can I define a synonym datatype called number for the default datatype
> numeric?
> I've this problem because I want to convert Oracle DB schemas to postgresql,
> and I would like not to convert all my script for generating the db.
> TIA

Assuming you're running 7.3, you can do

create domain number as numeric(12,2);

or something similar.