Skip site navigation (1) Skip section navigation (2)

Modifying ENUM Type

From: APseudoUtopia <apseudoutopia(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Modifying ENUM Type
Date: 2009-05-30 07:55:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

I created an ENUM type. However, I accidentally typoed in one of the
enum values. It is "apps" and it should be "app". What's the best way
to modify this without dropping the type? I have many tables which
have columns that depend on the type, and I'm trying to avoid having
to recreate all those tables again (which would be the case if I have
to drop the type).

Can I just edit the pg_enum table manually? Will this mess anything up?



pgsql-general by date

Next:From: Stefan KaltenbrunnerDate: 2009-05-30 09:07:54
Subject: Re: Switching databases over JDBC/ODBC
Previous:From: Scott BaileyDate: 2009-05-30 07:46:33
Subject: Re: Switching databases over JDBC/ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group