Postgres Pro
Downloads
Home   >   mailing lists

Re: forgot the structure of a composite type - Mailing list pgsql-admin

From Tom Lane
Subject Re: forgot the structure of a composite type
Date
Msg-id 10198.1238381101@sss.pgh.pa.us
Whole thread Raw
In response to forgot the structure of a composite type  (Manal Helal <manalorama@gmail.com>)
List pgsql-admin
Tree view 
Manal Helal <manalorama@gmail.com> 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

pgsql-admin by date:

Previous
From: Manal Helal
Date:
Subject: forgot the structure of a composite type
Next
From: fatih ozturk
Date:
Subject: Partitionin with check functions