Manal Helal <manalorama@xxxxxxxxx> writes: > I defined a composite type and forgot its structure, data fields names > and data types. Is there any command that can define that for me? psql's \d command, for one. regression=# create type fooey as (f1 int, f2 text); CREATE TYPE regression=# \d fooey Composite type "public.fooey" Column | Type --------+--------- f1 | integer f2 | text regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
