How can you determine the number of user defined types. Does the pg_type table has some entry which indicates that it is a user defined type and not a pre-defined one?
On Wed, Aug 18, 2010 at 8:45 PM, Sean Anderson
<iamthepants@gmail.com> wrote:
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@linux.com> wrote:
On 18 August 2010 04:39, STA <iamthepants@gmail.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
--
Thanks & Regards,
Siddharth Saha
Software Engineer | Drishti-Soft Solutions Pvt Ltd | Gurgaon, Delhi-NCR, India
Phone: +91-9711229624 | email: siddharthsaha@drishti-soft.com