Re: Alias for data types?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Matt Clark <mclark(at)rushe(dot)aero(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Alias for data types?
Date: 2003-03-31 16:23:06
Message-ID: 3E886B6A.4040106@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Matt Clark wrote:
> Is there a way to define an alias or synonym for a data type?
>
> I have an existing schema (from a Sybase DB), which defines a datatype via the
> SQLServer method:
>
> EXEC sp_addtype XID, 'numeric(16,0)' , 'NULL';
>

Take a look at DOMAINs:

http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/sql-createdomain.html

HTH,

Joe

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-03-31 18:13:31 Re: Alias for data types?
Previous Message Matt Clark 2003-03-31 16:16:07 Alias for data types?