Postgres Pro
Downloads
Home   >   mailing lists

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

From Jürgen Hauser
Subject Enum in PostgreSQL - How to
Date
Msg-id 5.1.0.14.2.20030407142242.00ab3c38@62.99.205.120
Whole thread Raw
Responses Re: Enum in PostgreSQL - How to  ("Dan Langille" <dan@langille.org>)
Re: Enum in PostgreSQL - How to  ("Nils O." Selåsdal <nos@utel.no>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Dan Langille"
Date:
Subject: possible time change issue - known problem?
Next
From: "Dan Langille"
Date:
Subject: Re: Enum in PostgreSQL - How to