Обсуждение: viewing definition of "CREATE TYPE name AS ENUM..."

After a type is created, is it possible to view the definition of this type?

There is no direct system information function like pg_get_indexdef etc, but you can find the enum labels in pg_enum catalog table, and there are some enum support functions

See if they help you http://www.postgresql.org/docs/8.3/static/functions-enum.html




--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar

--- On Thu, 11/29/07, Usama Dar <munir.usama@gmail.com> wrote:

> See if they help you
> http://www.postgresql.org/docs/8.3/static/functions-enum.html


I will give this a try, thanks!

Regards,
Richard Broersma Jr.