Re: Datatype Definition

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.