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

Peter Willis peterw at borstad.com
Thu Apr 9 10:53:40 PDT 2009


Carson Farmer wrote:
> Peter,
>>
>>> What tool did you use to import the layer into POSTGIS?
>>
>> Quantum GIS.
> My guess is you actually used the SPIT plugin, which is a C++ plugin 
> included with QGIS, and is a gui frontend to shp2pgsql...
> 
> Carson

Yes, that is correct.
Are there any other 'shp ingesters' for use with QGIS?

I am thinking that my complaint regarding proper normal form
for vector data ingested into postgresql should also be tempered
with the idea that any database user could reorganize the ingested
data into any format they desire. Therefore, it's not as though
anything is actually irreparably disorganized or broken.

Technically one could just add a trigger to the system catalogs
to check if a new table has been added to the database and then
go from there.


Peter



More information about the Qgis-user mailing list