Re: [GENERAL] How to view user defined TYPE

2008-10-22 Thread Tom Lane
Goboxe <[EMAIL PROTECTED]> writes: >> Let say I created a new type: >> CREATE TYPE compfoo AS (f1 int, f2 text); >> How can I view its definition? In psql, \d works: regression=# CREATE TYPE compfoo AS (f1 int, f2 text); CREATE TYPE regression=# \d compfoo Composite type "public.compfoo" Column

Re: [GENERAL] How to view user defined TYPE

2008-10-22 Thread Goboxe
Hi, Any help on the question below? Thanks. On Oct 15, 6:00 pm, Goboxe <[EMAIL PROTECTED]> 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 > displa