Re: Enum in PostgreSQL - How to

From: "Nils O(dot)" Selåsdal <nos(at)utel(dot)no>
To: Jürgen Hauser <hauser(at)pandora(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Enum in PostgreSQL - How to
Date: 2003-04-07 14:03:17
Message-ID: 1049724196.1217.10.camel@nos-rh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-07 14:25:57 Re: chron scripts and pgsql
Previous Message Manfred Koizar 2003-04-07 13:29:17 Re: unable to dump database, toast errors