| Re: [udig-users] PostGIS: Multiple geometry columns on one table |
Hi James, Have a look into the table "geometry_columns" in your postgis database. In that table, you will find two columns by the names of f_table_name and f_geometry_colulmn. As far as my knowledge goes, this specifies which column will be fetched from a particular table as a geometry column. If you change the value of f_geometry_colulmn with the column you want to display, then I think it should work. But be careful in doing so, as there is another column in this table which specifies the type of the geometry you want to use and this might conflict as one of the column may have POINTs however other column may contain POLYGONs in your table. If you do the above mentioned change, then I think it might get reflected in uDig. However, I can not be certain, since I have never tried it myself. Option 2 You might also want to re-think about your database design and try to use two tables instead of one but with Foreign Key constraints. The second table will only hold id(PK), data_id(FK to original table) and Geometry Column. Hence, not replicating the rest of the information as such in the first table. I hope this helps. Cheers, Farrukh. --- On Thu, 3/12/09, demichej <james.demichele@xxxxxxxxxx> wrote:
|