Re: Datatype Definition - Mailing list pgsql-general

From scott.marlowe
Subject Re: Datatype Definition
Date
Msg-id Pine.LNX.4.33.0305161254140.4710-100000@css120.ihs.com
Whole thread Raw
In response to Datatype Definition  ("Vincenzo Alberico" <v.alberico@libero.it>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Rollback when value too long
Next
From: "scott.marlowe"
Date:
Subject: Re: How to run more the one database at once ?