--- On Mon, 9/22/08, Jagadeesh <mnjagadeesh@gmail.com> wrote:
> From: Jagadeesh <mnjagadeesh@gmail.com>
> Subject: [ADMIN] displaying enum
> To: pgsql-admin@postgresql.org
> Date: Monday, September 22, 2008, 1:20 PM
> Hi admins,
>
> I had created enum and forgotten what were the values. Is
> there any
> way to see what I created?
>
> Thanks
what version of postgresql you have?
try this query
select * from pg_type a,pg_enum b
where a.oid = b.enumtypid