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

Obe, Regina robe.dnd at cityofboston.gov
Wed Aug 1 04:06:45 PDT 2007

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,

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Boehm, Andreas
Sent: Wednesday, August 01, 2007 5:42 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Retrieve all tables and views with geometry

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...


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

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.

More information about the postgis-users mailing list