[Qgis-user] Relational Databases and PostGIS formatting of Vector Data

[Peter Willis]

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.