Re: Enum in PostgreSQL - How to

On Mon, 2003-04-07 at 14:24, Jürgen Hauser wrote:
> Hello!
>
> Could somebody tell me how i would simulate an ENUM columntype (as in
> MySQL). For example:
>
> accountType ENUM('default', 'custom') default='default'
accountType varchar(10) CHECK (accountType='default' or
accountType='custom) DEFAULT 'default'


--
Vennlig hilsen/Best Regards
Nils Olav Selåsdal
System Engineer
UtelSystems a/s
Tlf: 370 45 431
Mob: 416 97 995
w w w . u t e l s y s t e m s . c o m