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 > [email protected] > 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
