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 On Nov 29, 2007 1:53 PM, Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > After a type is created, is it possible to view the definition of this > type? > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Usama Munir Dar http://linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar