how to alter an enum type

From: Henrique Pantarotto <henpa(at)terra(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: how to alter an enum type
Date: 2007-12-24 08:48:53
Message-ID: 20071224064439.AF91.HENPA@terra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2007-12-24 14:37:33 pg_ctl start fails on Windows
Previous Message Richard Broersma Jr 2007-12-24 03:31:16 Re: possible psql \d bug in 8.3 beta2