Skip site navigation (1) Skip section navigation (2)

Re: List of User Defined Types?

From: Siddharth Saha <siddharthsaha(at)drishti-soft(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: List of User Defined Types?
Date: 2010-09-17 10:36:54
Message-ID: AANLkTim7jPxVhcrCG+k8VjYA1Vg=tQA6e_nvQP6AEcsq@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)gmail(dot)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(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
>>
>
>


-- 

*Thanks & Regards**,*

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

Phone: +91-9711229624 | email: siddharthsaha(at)drishti-soft(dot)com

In response to

Responses

pgsql-novice by date

Next:From: Siddharth SahaDate: 2010-09-17 10:44:38
Subject: Re: Some Questions About SQL Functions
Previous:From: Salil WadnerkarDate: 2010-09-17 10:14:35
Subject: Re: transaction is read-only error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group