Re: Getting info on index - Mailing list pgsql-novice

From Francisco Reyes
Subject Re: Getting info on index
Date
Msg-id 20011107144820.D27009-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Getting info on index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Wed, 7 Nov 2001, Tom Lane wrote:

> Francisco Reyes <lists@natserv.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??)?


pgsql-novice by date:

Previous
From: David Link
Date:
Subject: Re: IS NULL
Next
From: Francisco Reyes
Date:
Subject: Index not used on single select, but used in join.