| From: | "Usama Dar" <munir(dot)usama(at)gmail(dot)com> |
|---|---|
| To: | "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com> |
| Cc: | "General PostgreSQL List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: viewing definition of "CREATE TYPE name AS ENUM..." |
| Date: | 2007-11-29 16:27:32 |
| Message-ID: | ff0e67090711290827q3c3d6168if9c05322a9618cbb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2007-11-29 16:30:54 | Re: HD is flooded by Error Log info |
| Previous Message | Stefan Niantschur | 2007-11-29 16:23:25 | pgcrypto functions fail for asymmetric encryption/decryption |