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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jagadeesh | 2008-09-23 05:17:27 | Re: 40歳以上で心も身体も癒やされたい方は[癒やし家]へお越し下さい。 |
Previous Message | Tom Lane | 2008-09-23 03:37:10 | Re: Select all table column names for a specified tablename (per the system catalogs) |