Manal Helal <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
