On Mon, Jul 19, 2004 at 16:46:08 +0200,
Michael Kleiser <mkl@webde-ag.de> wrote:
> I don`t know, if there is a special feature in postgresql for this.
> The standard SQL-way is to create a lookup-table and define a foreign-key
> to it.
You could also use a domain which constrains one of its columns to a
few values. I don't think this would be appropiate for a large list,
like the list of use states. But you might do this when there are fewer
values and you don't expect the list to change.