Re: Enum - Mailing list pgsql-general

From John R Pierce
Subject Re: Enum
Date
Msg-id 4A9DB383.9030309@hogranch.com
Whole thread Raw
In response to Enum  (Xai <rellonlawrence@gmail.com>)
List pgsql-general
Xai wrote:
> Is there a query i can use to get the fields of an Enum, just in case
> someone needs it for the client application.
>


select e.enumlabel from pg_enum as e join pg_type as t on (t.typtype='e'
and e.enumtypeid=t.typbasetype) where t.typname = $1 order by e.enumtypid;


I think.  or something close to that.



pgsql-general by date:

Previous
From: Xai
Date:
Subject: Enum
Next
From: Narendra Shah
Date:
Subject: Re: No buffer space available