[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