Alex Mandel wrote:
I'm a little lost here, in my experience a vector layer becomes a table, not multiple tables and all the geometries are stored in a blob column no matter what type it is.
That's what I'm curious about. Each vector is becoming a table unto itself. That's not proper normal form for a relational database.
Of course if you have multiple vector types in the same table this can cause issues with various spatial operations, so you either need to separate them out or subquery when you want to perform spatial operations to make sure you only use compatible types.
Yes, this is exactly what you want when using a relational database in the proper manner.
What tool did you use to import the layer into POSTGIS?
Quantum GIS. _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user