Re: viewing definition of "CREATE TYPE name AS ENUM..."

["Usama Dar" <munir.usama@xxxxxxxxx>]

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 <rabroersma@xxxxxxxxx> 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