Re: How to view user defined TYPE

From: Goboxe <hadzramin(dot)ar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to view user defined TYPE
Date: 2008-10-22 15:55:52
Message-ID: 766d90f3-a7e4-44db-b09a-42b903c4b716@r36g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Any help on the question below? Thanks.

On Oct 15, 6:00 pm, Goboxe <hadzramin(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> Hi,
>
> Let say I created a new type:
>
> CREATE TYPE compfoo AS (f1 int, f2 text);
>
> How can I view its definition?
>
> I tried to view it in pgAdmin but seems cannot fine any node that
> display that?
>
> Thanks,
> G

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-10-22 16:26:33 gin index and same query misteriously slowing down on a nearly-readonly DB
Previous Message Ben Chobot 2008-10-22 15:51:04 Re: How to get schema name which violates fk constraint