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.