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

Re: List of User Defined Types?

From: Thom Brown <thom(at)linux(dot)com>
To: STA <iamthepants(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: List of User Defined Types?
Date: 2010-08-18 06:54:22
Message-ID: AANLkTikVWeN61rvMu=GsuybkJKDsmG7BBRH2NVz2Kty1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Amit SoniDate: 2010-08-18 07:52:51
Subject: Limiting the size of log files
Previous:From: STADate: 2010-08-18 03:39:14
Subject: List of User Defined Types?

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