Re: Getting info on index

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??)?

In response to

Browse pgsql-novice by date

  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