Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql's "\d" and CLUSTER

psql's "\d" and CLUSTER

From
Igor Shevchenko
Date:
Hi,

Are there any plans on adding CLUSTER-related information to "\d tablename" ?

--
Best regards,
Igor Shevchenko

Re: psql's "\d" and CLUSTER

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: psql's "\d" and CLUSTER

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073