Re: Enumerated data type - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Enumerated data type
Date
Msg-id Pine.LNX.4.21.0005022200330.362-100000@localhost.localdomain
Whole thread Raw
In response to Enumerated data type  ("Anand Raman" <araman@india-today.com>)
Responses Re: Enumerated data type  (Tom Cook <tcook@lisa.com.au>)
List pgsql-general
Anand Raman writes:

> Is there anything equivalent to the enumerated data types in
> postgresql..

You might find that strings with check constraints will do the job, e.g.

create table my_tbl (
 ...
 color text check color in ('blue', 'green', 'white'),
 ...
);


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: Re: RE: One last thing... psql and readline
Next
From: "Culberson, Philip"
Date:
Subject: RE: Need help with attributes...