From: Lennin Caro <lennin.caro@yahoo.com>
To: pgsql-admin@postgresql.org, Jagadeesh <mnjagadeesh@gmail.com>
Subject: Re: displaying enum
Date: Mon, 22 Sep 2008 08:56:30 -0700 (PDT)
Message-ID: <424829.9369.qm@web59503.mail.ac4.yahoo.com> (raw)
In-Reply-To: <bd20cf2a-032b-4822-ba85-d2315ea259eb@w1g2000prk.googlegroups.com>
--- On Mon, 9/22/08, Jagadeesh <mnjagadeesh@gmail.com> wrote:
> From: Jagadeesh <mnjagadeesh@gmail.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lennin.caro@yahoo.com, mnjagadeesh@gmail.com
Subject: Re: displaying enum
In-Reply-To: <424829.9369.qm@web59503.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox