Enum in PostgreSQL - How to

From: Jürgen Hauser <hauser(at)pandora(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: Enum in PostgreSQL - How to
Date: 2003-04-07 12:24:52
Message-ID: 5.1.0.14.2.20030407142242.00ab3c38@62.99.205.120
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

Could somebody tell me how i would simulate an ENUM columntype (as in
MySQL). For example:

accountType ENUM('default', 'custom') default='default'

How can i do this in PostgreSQL ?

Thanks a lot in advance for your time and effort.

Best regards,
Jürgen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Langille 2003-04-07 12:41:02 Re: Enum in PostgreSQL - How to
Previous Message Dan Langille 2003-04-07 12:19:57 possible time change issue - known problem?