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

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

In response to

Responses

Browse pgsql-general by date

  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