Re: how to find index columns

On Dec 5, 2006, at 11:17 PM, Andrew - Supernews wrote:

> Way ahead of you: http://pgfoundry.org/projects/newsysviews/ (see the
> source code repo, there are no releases)

Neat.  I looked at this:

http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/ 
sql/indexes.sql?rev=1.2

Seems both views are missing the indexed column name(s).  I ran into  
a situation where I needed to present a list of all indexed columns  
on a table, hence my "information_schema.indexes" view.  It attempts  
to parse the columns from the index definition.  It just can't parse  
definitions that use functional indexes.

Maybe you can consider adding a similar column to these views?   
Output the column names as a name[] and maybe add another column for  
"functional_definition"?  Maybe Postgres could maintain that  
information in the system catalogs, but I suppose there's a good  
reason it doesn't already do that.

Just a thought.

eric

>
> (though that was written for 7.4 and 8.0, and needs some fixing for  
> 8.1
> still (though almost all of it works), and I haven't even tried it  
> on 8.2
> yet)
>
> -- 
> Andrew, Supernews
> http://www.supernews.com - individual and corporate NNTP services
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate