How to determine whether a view's column is indexed? - Mailing list pgsql-general

From Martin Schäfer
Subject How to determine whether a view's column is indexed?
Date
Msg-id 37936EEC582B394A9E1AA951991A551609D119@dev001_pdc.Dev.cadcorp.net
Whole thread Raw
List pgsql-general
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
 

pgsql-general by date:

Previous
From: "Scot L. Harris"
Date:
Subject: Re: Multiple databases on seperate drives/file systems?
Next
From: Prabu Subroto
Date:
Subject: Re: postgres on SuSE 9.1