[postgis-users] Adding view to geometry_columns table
Milo van der Linden
mlinden at zeelandnet.nl
Fri Mar 21 01:18:47 PDT 2008
There are no pitfalls, working with views in the geometry_columns is the
way to do it. It doesn't matter what non geometry columns you change, as
long as you leave the geometry column in place.
The only thing is that when you want to use QuantumGIS to have edit
access you need to do it on the table directly, not on the view.
Lee Hachadoorian schreef:
> 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?
> Lee Hachadoorian
> PhD Student, Geography
> Program in Earth & Environmental Sciences
> CUNY Graduate Center
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users