Hi Astrid, The only way of doing what you suggest is to create your table, then add views splitting out the geometries into the different types for use in QGIS. Update rules may need to be applied to the views to support editing through them
There are other ways of achieving a similar effect, but this is the only way to have the single database geometry column that you specify. If your use case allows this, I suggest you revisit your requirement for a single table, so that you manage your underlying data in separate tables, & apply a view unioning the tables into the single database view. I think this will be a more robust way to have the editing & data management facilities, & the apparent single table/column that you require. Brent Wood --- On Mon, 12/17/12, Astrid Emde <astrid.e...@wheregroup.com> wrote: From: Astrid Emde <astrid.e...@wheregroup.com> Subject: [Qgis-user] How to digitze points, linestrings, polygons in a single PostGIS geometry-column To: qgis-user@lists.osgeo.org Date: Monday, December 17, 2012, 9:22 PM Hello, in a project I want to handle in one PostgreSQl/PostGIS table different geometrytypes (POINT, LINESTRING, POLYGON or even MULTI-objects) in a single geometrycolumn. Then I would like to digitize with QGIS new objects. Is this possible? I tried it already but in QGIS it is not possible to select the different geometrytypes although I already have different geometrytypes in the table. I tried with the TYPE GEOMETRYCOLLECTION too, but QGIS seams not to support this at all. I am using PostGIS 1.5 and QGIS 1.8.0. Thanks for your help. -- Best regards Astrid Emde ---------------------------------- Astrid Emde WhereGroup GmbH & Co.KG Eifelstraße 7 53119 Bonn Germany Fon: +49(0)228 90 90 38 - 19 Fax: +49(0)228 90 90 38 - 11 astrid.e...@wheregroup.com www.wheregroup.com Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com Amtsgericht Bonn, HRA 6788 ------------------------------- Komplementärin: WhereGroup Verwaltungs GmbH vertreten durch: Olaf Knopp, Peter Stamm ------------------------------- pgp-public key: http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284 Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen Signed and/or encrypted mail is highly appreciated _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user