From: | Sean Anderson <iamthepants(at)gmail(dot)com> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: List of User Defined Types? |
Date: | 2010-08-18 15:15:27 |
Message-ID: | AANLkTimzx7xNcy4qdLbtXMHwddz8NLhbo=eJ=UXA_6si@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thom - thank you so much. This is exactly what I was looking for, and is
very much appreciated.
On Wed, Aug 18, 2010 at 2:54 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 18 August 2010 04:39, STA <iamthepants(at)gmail(dot)com> wrote:
> > Is there a way to bring up a list of user defined types either as a
> > query or in the pgAdmin UI?
> >
> > The reason I'm asking is that I've created several types in order to
> > return SETOF [mytype] in functions, and it would be handy to be able
> > to view all these custom types in one place. Does such a node exist
> > somewhere in the pgAdmin object browser? I see the Type displayed in
> > the dependencies tab in the function properties; it would be nice if
> > you could double-click that type and see the original CREATE TYPE
> > statement.
> >
>
> If you're using PgAdmin, you can enable the display of user types by
> going to: File > Options > Display (tab) > then ticking "Types".
>
> In psql you can use \dT or \dT+
>
> They will also be listed in pg_catalog.pg_type table.
>
> Regards
> --
> Thom Brown
> Registered Linux user: #516935
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chip Steele | 2010-08-18 15:20:20 | Streaming Replication in PostgreSQL9.0 b4: Standby dropping connections |
Previous Message | Amit Soni | 2010-08-18 14:58:28 | Re: Limiting the size of log files |