Re: Enum in PostgreSQL - How to - Mailing list pgsql-general

From Nils O." Selåsdal
Subject Re: Enum in PostgreSQL - How to
Date
Msg-id 1049724196.1217.10.camel@nos-rh
Whole thread Raw
In response to Enum in PostgreSQL - How to  (Jürgen Hauser <hauser@pandora.be>)
Responses Re: Enum in PostgreSQL - How to  (Jürgen Hauser <hauser@pandora.be>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: unable to dump database, toast errors
Next
From: Tom Lane
Date:
Subject: Re: chron scripts and pgsql