Re: psql: \d+ show tablespace of indices - Mailing list pgsql-patches

From Tom Lane
Subject Re: psql: \d+ show tablespace of indices
Date
Msg-id 29819.1117764955@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql: \d+ show tablespace of indices  (Neil Conway <neilc@samurai.com>)
Responses Re: psql: \d+ show tablespace of indices  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
Neil Conway <neilc@samurai.com> writes:
> On Mon, 2005-05-23 at 18:52 +0800, Qingqing Zhou wrote:
>> Now \d+ is able to show the tablespace details of indices.

> Should this be included in \d? Tablespace information for the table
> itself is, so I think we should probably do the same for indexes.

Seems reasonable.  In the minor-carping department, I didn't much like
the formatting:

Indexes:
    "mi" btree (i) - Tablespace: "testspace"
    "mj" btree (j)

That looks a bit ugly to me ... not sure why, exactly, but maybe it's
that there's too much punctuation.  The underlying CREATE INDEX command
would just look like

    "mi" btree (i)  tablespace "testspace"

Does that look better or worse to you?

            regards, tom lane

pgsql-patches by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Oracle date type compat. functions: next_day, last_day,
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Simplify Win32 Signaling code