Skip site navigation (1) Skip section navigation (2)

Re: psql: \d+ show tablespace of indices

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>,pgsql-patches(at)postgresql(dot)org
Subject: Re: psql: \d+ show tablespace of indices
Date: 2005-06-03 02:15:55
Message-ID: 29819.1117764955@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Neil Conway <neilc(at)samurai(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2005-06-03 03:17:21
Subject: Tablespaces
Previous:From: Neil ConwayDate: 2005-06-03 01:25:06
Subject: Re: psql: \d+ show tablespace of indices

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2005-06-03 03:17:21
Subject: Tablespaces
Previous:From: Christopher Kings-LynneDate: 2005-06-03 01:36:58
Subject: Re: Oracle date type compat. functions: next_day, last_day,

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group