Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Broersma Jr
Subject Re: how to alter an enum type
Date
Msg-id 135306.26135.qm@web31805.mail.mud.yahoo.com
Whole thread Raw
In response to how to alter an enum type  (Henrique Pantarotto <henpa@terra.com.br>)
Responses Re: how to alter an enum type
List pgsql-general
Tree view 
--- 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.

pgsql-general by date:

Previous
From: Gordon
Date:
Subject: Re: Postgres from PHP in Leopard
Next
From: Richard Broersma Jr
Date:
Subject: Re: pg_ctl start fails on Windows