Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id D50C364FC2D
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 22 Sep 2008 11:53:56 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 90967-05-2 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 22 Sep 2008 11:53:45 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.238])
	by postgresql.org (Postfix) with ESMTP id 31F2964FC33
	for <pgsql-admin@postgresql.org>; Mon, 22 Sep 2008 11:53:07 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id b25so1412140rvf.43
	for <pgsql-admin@postgresql.org>; Mon, 22 Sep 2008 07:53:06 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=bqnaMr5pMqtPdiuapwMSN+mijnXsoSXO7mT33sgLtcs=;
	b=HVZcvb9xyWEOa8YMKdFKXWIm8mluziXcJoAOK4v1VDzrnSntFRUlZRD6AV6iPZYYp7
	6x6K1F4Q1YORt0LkMpW0P0o2engL0/62DPwhsOritf52q7+683W/Xzy3GT7jj6ipJHUY
	OcvRWTYTgYU8v8jbTSmU5KbLtsqgFxJi80sqs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=Nnfhf0jcDTf1o8de79HIK4KmfWAW72thApN+oghJbNLkdv2SQEL2PjkQY+1+SZVPP8
	BB3ho/4nmws4V7vVZE16bx/KuH73lmLtbV0EpJIMJRJjSMyPoE6iFQOAzu1HHaUKFKHO
	1fwD8DpkCdaNDxovlVxVyrpbdMgc9CoJlDl1E=
Received: by 10.140.204.7 with SMTP id b7mr2021032rvg.149.1222095186081;
	Mon, 22 Sep 2008 07:53:06 -0700 (PDT)
Received: by 10.141.189.17 with HTTP; Mon, 22 Sep 2008 07:53:05 -0700 (PDT)
Message-ID: <f1d4f3170809220753l990ccc4x3988d13754757b77@mail.gmail.com>
Date: Mon, 22 Sep 2008 10:53:06 -0400
From: chirag.dave@gmail.com
To: Jagadeesh <mnjagadeesh@gmail.com>
Subject: Re: displaying enum
Cc: pgsql-admin@postgresql.org
In-Reply-To: 
 <bd20cf2a-032b-4822-ba85-d2315ea259eb@w1g2000prk.googlegroups.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_53985_31739694.1222095186059"
References: <bd20cf2a-032b-4822-ba85-d2315ea259eb@w1g2000prk.googlegroups.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200809/229
X-Sequence-Number: 30322

------=_Part_53985_31739694.1222095186059
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Assuming you are are running 8.3, you can do this:

SELECT a.typname,b.enumlabel from pg_type a , pg_enum b where
a.oid=b.enumtypid and a.typname='NAME_OF_ENUM';

Chirag Dave
Afilias


On Mon, Sep 22, 2008 at 9:20 AM, Jagadeesh <mnjagadeesh@gmail.com> wrote:

> Hi admins,
>
> I had created enum and forgotten what were the values. Is there any
> way to see what I created?
>
> Thanks
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

------=_Part_53985_31739694.1222095186059
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Assuming you are are running 8.3, you can do this:<br><br>SELECT a.typname,b.enumlabel from pg_type a , pg_enum b where a.oid=b.enumtypid and a.typname=&#39;NAME_OF_ENUM&#39;;<br><br>Chirag Dave<br>Afilias<br>
<br><br><div class="gmail_quote">On Mon, Sep 22, 2008 at 9:20 AM, Jagadeesh <span dir="ltr">&lt;<a href="mailto:mnjagadeesh@gmail.com">mnjagadeesh@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi admins,<br>
<br>
I had created enum and forgotten what were the values. Is there any<br>
way to see what I created?<br>
<br>
Thanks<br>
<font color="#888888"><br>
--<br>
Sent via pgsql-admin mailing list (<a href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-admin" target="_blank">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</font></blockquote></div><br></div>

------=_Part_53985_31739694.1222095186059--