Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to determine whether a view's column is indexed?

How to determine whether a view's column is indexed?

From
Martin Schäfer
Date:
Is there any way to find out whether a column that's used in a view is indexed?
 
I can find out whether a table's column is indexed by going through the pg_class, pg_attribute and pg_index system catalogs. But I haven't been able to extend that method to views.
 
Can anybody help?
 
Martin