Re: how to find index columns

On 2006-12-06, "Eric B. Ridge" <ebr(at)tcdi(dot)com> wrote:
> 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?

Still way ahead of you: see the index_columns views.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services