Обсуждение: List of User Defined Types?

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.

Thanks in advance,
STA

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

Thom - thank you so much. This is exactly what I was looking for, and is very much appreciated.

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?






--

Thanks & Regards,

Siddharth Saha
Software Engineer | Drishti-Soft Solutions Pvt Ltd | Gurgaon, Delhi-NCR, India

Phone: +91-9711229624 | email: siddharthsaha@drishti-soft.com

Siddharth Saha <siddharthsaha@drishti-soft.com> writes:
> 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?

There isn't any hard and fast distinction betweem built-in and
user-defined types.

Depending on what you're doing, you might want to consider a type
"built-in" if it resides in the pg_catalog or information_schema
schemas (I think this is the definition psql's \dT uses).  Or you
could check whether the type's OID is less than 16384, which would
tell you whether it was created during initdb.

            regards, tom lane