| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2005-06-03 03:17:21 | Tablespaces |
| Previous Message | Neil Conway | 2005-06-03 01:25:06 | Re: psql: \d+ show tablespace of indices |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2005-06-03 03:17:21 | Tablespaces |
| Previous Message | Christopher Kings-Lynne | 2005-06-03 01:36:58 | Re: Oracle date type compat. functions: next_day, last_day, |