Re: How to view user defined TYPE
Started by Goboxeover 17 years ago2 messagesgeneral
Hi,
Any help on the question below? Thanks.
Show quoted text
On Oct 15, 6:00 pm, Goboxe <hadzramin...@gmail.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
Import Notes
Reference msg id not found: a9d64603-8395-42c1-82a6-93735dd15449@f40g2000pri.googlegroups.com
Goboxe <hadzramin.ar@gmail.com> 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 | Type
--------+---------
f1 | integer
f2 | text
regards, tom lane