[postgis-users] How to determine whether a view's geometry column is indexed?

Martin Schäfer Martin.Schaefer at cadcorp.com
Tue Jun 1 00:58:41 PDT 2004


Is there any way to find out whether a geometry column that's used in a view is indexed?
I can find out whether a table's geometry 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.
 
Any help?
 
Martin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040601/e5559928/attachment.html>


More information about the postgis-users mailing list