Re: displaying enum

On Sep 22, 8:56 pm, lennin(dot)c(dot)(dot)(dot)(at)yahoo(dot)com (Lennin Caro) wrote:
> --- On Mon, 9/22/08, Jagadeesh <mnjagade(dot)(dot)(dot)(at)gmail(dot)com> wrote:
>
> > From: Jagadeesh <mnjagade(dot)(dot)(dot)(at)gmail(dot)com>
> > Subject: [ADMIN] displaying enum
> > To: pgsql-ad(dot)(dot)(dot)(at)postgresql(dot)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
>
> --
> Sent via pgsql-admin mailing list (pgsql-ad(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin

Thanks for helping me.
Here is the postres server version I am using.

server_version
----------------
8.3.1

Your query is not describing enum. but I think its listing meta info
about the enums.

Thanks
Jagadeesh