[postgis-users] Updated shapefile to update postgres database

[Martin Chapman]

Ogr2Ogr at http://www.gdal.org/ogr/ogr2ogr.html has append and update
options.  As long as your new columns were added to the end of the table it
will probably will work fine.

Best regards,
Martin


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of SenTnel
Sent: Tuesday, May 06, 2008 4:40 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Updated shapefile to update postgres database


Hello!

I would like some help updating a postgres database. This is the problem: We
created the database using shp2pgsql to convert a shapefile that contains a
city's street details (centerline), after we created the database we also
created an aditional column to classify the street types (eg: street,
avenues, highways, etc.), now we are working on the original shapefile,
updating new roads, changes made to highways due to constructions
modifications, etc., and we want to upload the "updated" shapefile, without
afecting the actual database, another words, we would like to convert to
postgres the updated shapefile with the new information (it cuold be the
whole shapefile) but to keep the added clasiffication column intact. How can
we do that?

Thanks
-- 
View this message in context:
http://www.nabble.com/Updated-shapefile-to-update-postgres-database-tp170535
62p17053562.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users