From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: \dT+ does not give elements ? |
Date: | 2011-12-02 21:54:49 |
Message-ID: | 25033.1322862889@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> writes:
> SImple/quick (hopefully)
> thedb=# \dT+
> List of data types
> Schema | Name | Internal name | Size | Elements | Description
> --------+-------------------+-------------------+-------+----------+-------------
> public | one_string_rec | one_string_rec | tuple | |
> public | pwr_stdb_data | pwr_stdb_data | tuple | |
> public | pwrrec | pwrrec | tuple | |
> public | tree_template_rec | tree_template_rec | tuple | |
> (4 rows)
> ...but no "elements". These are all record types. How can I see the composition of one of thest data types
Records don't have elements ... they have fields. That column is for
elements of enum types. If you want to see the fields of a record type,
just use "\d recordtype", as if it were a table.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Amiel | 2011-12-02 22:06:34 | Re: Oddball data distribution giving me planner headaches |
Previous Message | David Johnston | 2011-12-02 21:28:13 | Re: Oddball data distribution giving me planner headaches |