From: | Francisco Reyes <lists(at)natserv(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Pgsql Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Getting info on index |
Date: | 2001-11-07 19:54:01 |
Message-ID: | 20011107144820.D27009-100000@zoraida.natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 7 Nov 2001, Tom Lane wrote:
> Francisco Reyes <lists(at)natserv(dot)com> writes:
> > What, if anything, would show me the complete key of an index?
>
> You could use pg_get_indexdef, which is what pg_dump uses:
>
> regression=# select pg_get_indexdef((select oid from pg_class where relname = 'fooi'));
>
> There's been some talk of improving psql's \d facility to make use of
> this itself, but it's probably too late to do it for 7.2 ...
That would be very helpfull. I understand that 7.2 should be around the
corner, but how does it look for the next release (7.2.1??)?
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2001-11-07 20:10:46 | Index not used on single select, but used in join. |
Previous Message | David Link | 2001-11-07 19:25:47 | Re: IS NULL |