[postgis-users] geometry_columns table

Obe, Regina robe.dnd at cityofboston.gov
Tue Jul 1 04:02:06 PDT 2008

Those tables are only modified by PostGIS using the following functions
or by direct user intervention (yes you can modify it directly and I do
when I'm creating views since there is currently no way to make the
table add a view)
The postgis functions I know of that update that table are the
AddGeometryColumn()  -- which creates a new geometry field in a table
DropGeometryColumn() - which drops a geometry field that was created
with ST_AddGeometryColumn
probe_geometry_columns() - which adds new entries from tables that have
the respective check constraints created by AddGeometryColumn (or by
UpdateGeometrySRID() -  which updates all the SRIDS in a table geometry
column and also corrects the geometry_columns() table.
The plan in the future is to make geometry_columns a view which reads
from the PostgreSQL system catalogs.  When that is done, then it will
behave as you are expecting it to.
Hope that helps,


From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Sarel Coetzer
Sent: Tuesday, July 01, 2008 6:50 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] geometry_columns table


I have searched the forum but am still confused about the
geometry_columns table. Importing and deleting PostGIS layers doesn't
seem to have an effect on the geometry_columns table, very strange as
this is a GIS catalog to the spatial database.

I require this table (geometry_columns) to be updated every time the
Postgis DB is edited, can anyone help please?

How is this table created?
With which table does it have a relationship with?
How can I update this table to current PostGIS layers?

Thanks for your help in advance



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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080701/4b539b30/attachment.html>

More information about the postgis-users mailing list