Goboxe <hadzramin.ar@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
