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

From: Martin Schäfer <Martin(dot)Schaefer(at)cadcorp(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to determine whether a view's column is indexed?
Date: 2004-06-09 15:51:18
Message-ID: 37936EEC582B394A9E1AA951991A551609D119@dev001_pdc.Dev.cadcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Robert Fitzpatrick 2004-06-09 16:42:52 check constraint on char field
Previous Message Prabu Subroto 2004-06-09 15:39:30 Re: postgres on SuSE 9.1