[TLM] Re: how to alter an enum type - Mailing list pgsql-general

From Richard Broersma Jr
Subject [TLM] Re: how to alter an enum type
Date
Msg-id 20071224175327.32804414281@qatlm3.calidad2.pandasoftware.com
Whole thread Raw
In response to how to alter an enum type  (Henrique Pantarotto <henpa@terra.com.br>)
List pgsql-general
--- On Mon, 12/24/07, Henrique Pantarotto <henpa@terra.com.br> wrote:

> I tried searching the documentation and mailing list, and I
> couldn't
> figure this one out.

 ALTER TABLE questions
ALTER COLUMN answers TYPE possible_answers;

Actually your type is fine.  you only need to alter the column on your table to use your new type.

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

pgsql-general by date:

Previous
From: 杨雪枫
Date:
Subject: [TLM] It's serious,Help!
Next
From: Thomas Hart
Date:
Subject: weird date/times in mailing list