Skip site navigation (1) Skip section navigation (2)

Re: displaying enum

From: Jagadeesh <mnjagadeesh(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: displaying enum
Date: 2008-09-23 03:41:11
Message-ID: acd3cd28-7f72-4fab-add6-071db50aa31b@s9g2000prg.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

pgsql-admin by date

Next:From: JagadeeshDate: 2008-09-23 05:17:27
Subject: =?ISO-2022-JP?B?UmU6IDQwGyRCOlAwSj5lJEc/NCRiP0hCTiRiTH4kZCQ1JGwkPyQkGyhC?==?ISO-2022-JP?B?GyRCSn0kTxsoQlsbJEJMfiRkJDcySBsoQl0bJEIkWCQqMVskNzI8JDUkJCEjGyhC?=
Previous:From: Tom LaneDate: 2008-09-23 03:37:10
Subject: Re: Select all table column names for a specified tablename (per the system catalogs)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group