'enum' equivalent? - Mailing list pgsql-general

From Dan Lyke
Subject 'enum' equivalent?
Date
Msg-id 14956.33016.894496.485456@wynand.flutterby.com
Whole thread Raw
In response to 'enum' equivalent?  (Steve Leibel <stevel@bluetuna.com>)
List pgsql-general
Steve Leibel writes:
> I'm converting a mysql database to postgres.  Is there an equivalent
> for the enum data type?

No, but you can put the enum data in a separate table and join
them. This also makes the operation of adding entries to the enum list
better defined.

Dan

pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: "recovery mode"
Next
From: Joel Bernstein
Date:
Subject: Re: Why does the JDBC driver not support prepareCall?