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