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 |  Type   
--------+---------
 f1     | integer
 f2     | text


                        regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to