| Lists: | pgsql-generalpgsql-patches |
|---|
| From: | Igor Shevchenko <igor(at)carcass(dot)ath(dot)cx> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | psql's "\d" and CLUSTER |
| Date: | 2004-01-11 00:54:05 |
| Message-ID: | 200401110254.06582.igor@carcass.ath.cx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-patches |
Hi,
Are there any plans on adding CLUSTER-related information to "\d tablename" ?
--
Best regards,
Igor Shevchenko
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Igor Shevchenko <igor(at)carcass(dot)ath(dot)cx> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql's "\d" and CLUSTER |
| Date: | 2004-02-10 14:39:07 |
| Message-ID: | 200402101439.i1AEd7p14745@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-patches |
Igor Shevchenko wrote:
> Hi,
>
> Are there any plans on adding CLUSTER-related information to "\d tablename" ?
Is this a TODO?
--
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
| 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 |
| 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: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Igor Shevchenko <igor(at)carcass(dot)ath(dot)cx> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql's "\d" and CLUSTER |
| Date: | 2004-04-06 04:07:40 |
| Message-ID: | 200404060407.i3647eu17598@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-patches |
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