| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Igor Shevchenko <igor(at)carcass(dot)ath(dot)cx> |
| Cc: | PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] psql's "\d" and CLUSTER |
| Date: | 2004-03-31 04:46:11 |
| Message-ID: | 200403310446.i2V4kB920259@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
Igor Shevchenko wrote:
> Hi,
>
> Are there any plans on adding CLUSTER-related information to "\d tablename" ?
The attached patch displays cluster information for \d "table" and \di
"index":
test=> \d test2
Table "public.test2"
Column | Type | Modifiers
--------+---------+-----------
y | integer | not null
Indexes:
"test2_pkey" PRIMARY KEY, btree (y) CLUSTER
test=> \d test2_pkey
Index "public.test2_pkey"
Column | Type
--------+---------
y | integer
PRIMARY KEY, btree, for table "public.test2", CLUSTER
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 4.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ericson Smith | 2004-03-31 05:59:04 | Re: Wich hardware suits best for large full-text indexed |
| Previous Message | Brent Wood | 2004-03-31 02:00:44 | Re: Wich hardware suits best for large full-text indexed |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bwhite | 2004-03-31 08:10:33 | Question about rtrees (overleft replacing left in nodes) |
| Previous Message | Bruce Momjian | 2004-03-31 02:42:11 | Re: logging statement levels |