On Sun, Jan 21, 2001 at 10:33:02PM -0500, Steve Leibel wrote:
> Hello,
>
> I'm converting a mysql database to postgres. Is there an equivalent
> for the enum data type?
If you want to make a column limited to few certain values, you can
define it something like:
mycolumn varchar(3) check (mycolumn in ('foo', 'bar', 'baz'))
That would be somewhat similar in effec to mysql's
mycolumn enum('foo', 'bar', 'baz')
Zach
--
xach@xach.com Zachary Beane http://www.xach.com/