Re: Alias for data types? - Mailing list pgsql-novice

From Joe Conway
Subject Re: Alias for data types?
Date
Msg-id 3E886B6A.4040106@joeconway.com
Whole thread Raw
In response to Alias for data types?  (Matt Clark <mclark@rushe.aero.org>)
List 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


pgsql-novice by date:

Previous
From: Jens Eliasson
Date:
Subject: Re: Postmaster.pid & Unix domain socket errors, OS X
Next
From: Tom Lane
Date:
Subject: Re: Alias for data types?