[TLM] Re: how to alter an enum type

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org, Henrique Pantarotto <henpa(at)terra(dot)com(dot)br>
Subject: [TLM] Re: how to alter an enum type
Date: 2007-12-24 17:50:09
Message-ID: 20071224175327.32804414281@qatlm3.calidad2.pandasoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- On Mon, 12/24/07, Henrique Pantarotto <henpa(at)terra(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2007-12-24 17:54:48 Re: pg_ctl start fails on Windows
Previous Message Ivan Sergio Borgonovo 2007-12-24 15:13:17 pg_get_serial_sequences still have problems with downcasting