Re: displaying enum

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