--- 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
