how to alter an enum type - Mailing list pgsql-general

From Henrique Pantarotto
Subject how to alter an enum type
Date
Msg-id 20071224064439.AF91.HENPA@terra.com.br
Whole thread Raw
Responses Re: how to alter an enum type
Re: how to alter an enum type
[TLM] Re: how to alter an enum type
List pgsql-general
Hi,

I was wondering how can I alter an ENUM type?  I have created a table
like this:

create type possible_answers as enum('yes', 'no');
create table questions ( question text, answers possible_answers);
insert into questions values ('Do you like me?', 'yes');

So my question is... How can I change "possible_answers" to enum('yes',
'no', 'maybe')?

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


Thanks!




pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: possible psql \d bug in 8.3 beta2
Next
From: "Abraham, Danny"
Date:
Subject: pg_ctl start fails on Windows