Postgres Pro
Downloads
Home   >   mailing lists

Re: displaying enum - Mailing list pgsql-admin

From chirag.dave@gmail.com
Subject Re: displaying enum
Date
Msg-id f1d4f3170809220753l990ccc4x3988d13754757b77@mail.gmail.com
Whole thread Raw
In response to displaying enum  (Jagadeesh <mnjagadeesh@gmail.com>)
Responses Re: displaying enum  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view
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 <mnjagadeesh@gmail.com> 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 (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error while trying to back up database: out of memroy
Next
From: Tino Schwarze
Date:
Subject: Re: SIGKILL and force disconnecting user sessions