Postgres Pro
Downloads
Home   >   mailing lists

Re: viewing definition of "CREATE TYPE name AS ENUM..." - Mailing list pgsql-general

From Usama Dar
Subject Re: viewing definition of "CREATE TYPE name AS ENUM..."
Date
Msg-id ff0e67090711290827q3c3d6168if9c05322a9618cbb@mail.gmail.com
Whole thread Raw
In response to viewing definition of "CREATE TYPE name AS ENUM..."  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: viewing definition of "CREATE TYPE name AS ENUM..."  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: hibernate + postgresql ?
Next
From: Andrew Sullivan
Date:
Subject: Re: HD is flooded by Error Log info