Re: Alias to a type - Mailing list pgsql-sql

Veikko Mäkinen wrote:
> Hey,
>
> Is it possible to create a new type as an alias to a pre-defined type? I
> use "USERID varchar(20)" in almost every table I have I'd like to make
> an alias for that type eg.

CREATE DOMAIN username_string AS varchar(20);

Test it with your client applications though, make sure they cope. Some
don't cope well with user-defined types.
--   Richard Huxton  Archonet Ltd