<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=907595007-01062004><FONT face="Courier New"
size=2>Is there any way to find out whether a geometry column that's used
in a view is indexed?</FONT></SPAN></DIV>
<DIV><SPAN class=907595007-01062004><FONT face="Courier New" size=2>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.</FONT></SPAN></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><SPAN class=907595007-01062004>Any
help?</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV align=left>
<DIV class=Section1><SPAN class=907595007-01062004><FONT face="Courier New"
size=2>Martin</FONT></SPAN></DIV></DIV></BODY></HTML>