| From: | Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: psql: \d+ show tablespace of indices |
| Date: | 2005-06-04 06:54:26 |
| Message-ID: | Pine.GSO.4.58.0506040251440.9525@qew.cs |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Now \d show tablespace of indices per discussion.
test=# \d e
Table "public.e"
Column | Type | Modifiers
--------+---------+-----------
i | integer | not null
j | integer | not null
k | integer |
Indexes:
"e_pkey" PRIMARY KEY, btree (i, j), tablespace "haha"
"ei" btree (i)
"ej" btree (j), tablespace "haha"
"ek" btree (k)
Tablespace: "haha"
| Attachment | Content-Type | Size |
|---|---|---|
| describe.diff | text/plain | 5.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans-Jürgen Schönig | 2005-06-04 08:35:00 | Re: executing OS programs from pg |
| Previous Message | Tom Lane | 2005-06-04 04:37:35 | Re: Precedence of % |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2005-06-04 13:05:52 | Re: [HACKERS] Inefficiency in recent pgtz patch |
| Previous Message | Ron Mayer | 2005-06-04 06:05:43 | Re: Oracle date type compat. functions: next_day, last_day, |