From: | Dan Lyke <danlyke(at)flutterby(dot)com> |
---|---|
To: | Steve Leibel <stevel(at)bluetuna(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | 'enum' equivalent? |
Date: | 2001-01-22 18:50:32 |
Message-ID: | 14956.33016.894496.485456@wynand.flutterby.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Brian E. Pangburn | 2001-01-22 19:07:15 | [General] Comments |
Previous Message | Steve Wolfe | 2001-01-22 18:20:54 | "recovery mode" |
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2001-01-22 19:53:50 | Generating History |
Previous Message | Mikheev, Vadim | 2001-01-22 18:03:36 | RE: Beta 3 question(s) |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2001-01-22 20:40:53 | Re: postgres memory management |
Previous Message | Kogotkov, Vyacheslav | 2001-01-22 16:26:39 | JDBC2 question -- can't find files needed |