I usually just manually add my views into the geometry_columns table. Parsing could be done, but could slow things down enough to not be useful depending on how many tables you've got.
I heard some talk of in future releases having a trigger that automatically updates the geometry_columns table including views. Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boehm, Andreas Sent: Wednesday, August 01, 2007 5:42 AM To: [email protected] Subject: [postgis-users] 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 ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
