[postgis-users] Adding view to geometry_columns table

Lee Hachadoorian lee.hachadoorian at gmail.com
Thu Mar 20 16:03:51 PDT 2008


Is there any problem, or is it common, to add a view to the
geometry_columns table?  I'm experimenting using zigGIS to add PostGIS
layers to an ArcGIS 9.2 project.  It seems that zigGIS only "sees"
tables listed in geometry_columns (unlike Quantum GIS which "sees"
anything with a geometry column, including views based on tables with
geometry columns).  So I manually added a row to geometry_columns with
the names of the schema, view (in column f_table_name) and geometry
column.  Seems to be working fine, and this way I can easily add or
drop attributes from the layer, or join data from several different
tables.  Are there are any pitfalls I should be aware of?

Thanks,
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center



More information about the postgis-users mailing list