Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5EBCC64FC25 for ; Mon, 22 Sep 2008 12:57:14 -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 13592-01-8 for ; Mon, 22 Sep 2008 12:57:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n5b.bullet.mail.ac4.yahoo.com (n5b.bullet.mail.ac4.yahoo.com [76.13.13.75]) by postgresql.org (Postfix) with SMTP id 088FF64FCC1 for ; Mon, 22 Sep 2008 12:56:35 -0300 (ADT) Received: from [76.13.13.26] by n5.bullet.mail.ac4.yahoo.com with NNFMP; 22 Sep 2008 15:56:30 -0000 Received: from [76.13.10.167] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 22 Sep 2008 15:56:30 -0000 Received: from [127.0.0.1] by omp108.mail.ac4.yahoo.com with NNFMP; 22 Sep 2008 15:56:30 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 656129.22637.bm@omp108.mail.ac4.yahoo.com Received: (qmail 11393 invoked by uid 60001); 22 Sep 2008 15:56:30 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=UGDKgTDDQHgFBfWKcMRiS86+KKTVshakxGwgN8pDF3dw+drmuQfVm5OwFVVzMRpMhqOPeFVEAbnnY+7DrMyNJOwCPrI1RuEV5jq0NofqiHNiuaItdOq/Qy0EW6DUdRT2sOaVHJ5lYatYiJ4C7TpdfwVPVeaGKfv+f7Hi4SxbRc0=; X-YMail-OSG: bf5oi9MVM1kE512vWBkMBdZlLAIsRt1M4NHnxpE4KzOXO1poMC2FpvYt.ZA9vA8iEGUIwT6ObVrPc0PIIkDjzqqmfSXx__RcortURJgNRFQ9Ihw2Y9H9XGosN6c806ySHuj4Cd2mlDeBXHBmmz8myMs_jzyt Received: from [209.88.228.11] by web59503.mail.ac4.yahoo.com via HTTP; Mon, 22 Sep 2008 08:56:30 PDT X-Mailer: YahooMailWebService/0.7.218.2 Date: Mon, 22 Sep 2008 08:56:30 -0700 (PDT) From: Lennin Caro Reply-To: lennin.caro@yahoo.com Subject: Re: displaying enum To: pgsql-admin@postgresql.org, Jagadeesh In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <424829.9369.qm@web59503.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/231 X-Sequence-Number: 30324 --- On Mon, 9/22/08, Jagadeesh wrote: > From: Jagadeesh > Subject: [ADMIN] displaying enum > To: pgsql-admin@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