Re: psql's "\d" and CLUSTER

Igor Shevchenko wrote:
> Hi,
>
> Are there any plans on adding CLUSTER-related information to "\d tablename" ?

This will be in the 7.5 release:

test=> create table test (x int);
CREATE TABLE
test=> create index i on test(x);
CREATE INDEX
test=> cluster i on test;
CLUSTER
test=> \d test
Table "public.test"
Column | Type | Modifiers
--------+---------+-----------
x | integer |
Indexes:
"i" btree (x) CLUSTER

test=> \d i
Index "public.i"
Column | Type
--------+---------
x | integer
btree, for table "public.test", 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