[postgis-users] Retrieve all tables and views with geometry columns

[Armin Burger]

Hi Andreas

I used something like

SELECT c.relname 
FROM pg_attribute a, pg_class c, pg_type t, pg_namespace n 
WHERE a.attrelid=c.oid 
  AND a.atttypid=t.oid 
  AND t.typname='geometry' 
  AND (c.relkind = 'r' OR c.relkind = 'v') 
  AND c.relnamespace = n.oid

to get all tables and views with geometry columns. 

armin

-------- 
Subject: Retrieve all tables and views with geometry columns

> Hi list,
> 
> I would like to list all the geometry columns in a database. So the user
> can select the features he or she wants to see. Therefore I need to
> retrieve the database's metadata. 
> With "select * from geometry_columns" I'm able to get a list of all
> tables with geometry columns. But I don't get information about the
> _views_ with a geometry column. 
> Do I have to parse the definition text in pg_views? Maybe there is an
> easier way...
> 
> Thanks
> Andreas
> 
> P. S. Performance analyze with 250.000.000 points is still pending. I'll
> be back if I have further questions or results.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten 
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser