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