Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Richard Broersma Jr
Date:
After a type is created, is it possible to view the definition of this type?

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

From
"Usama Dar"
Date:
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@yahoo.com> 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

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

From
Richard Broersma Jr
Date:
--- 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.