Assuming you are are running 8.3, you can do this: SELECT a.typname,b.enumlabel from pg_type a , pg_enum b where a.oid=b.enumtypid and a.typname='NAME_OF_ENUM';
Chirag Dave Afilias On Mon, Sep 22, 2008 at 9:20 AM, Jagadeesh <[EMAIL PROTECTED]> wrote: > Hi admins, > > I had created enum and forgotten what were the values. Is there any > way to see what I created? > > Thanks > > -- > Sent via pgsql-admin mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
