On Sep 22, 8:56 pm, [EMAIL PROTECTED] (Lennin Caro) wrote: > --- On Mon, 9/22/08, Jagadeesh <[EMAIL PROTECTED]> wrote: > > > From: Jagadeesh <[EMAIL PROTECTED]> > > Subject: [ADMIN] displaying enum > > To: [EMAIL PROTECTED] > > 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 ([EMAIL PROTECTED]) > 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
