I have an existing PostgreSQL database table "city_data" with Non-spatial data in the following format:
City_ID as varchar, City_name as varchar, pop as int,....
I have enabled the PostGIS extension to this existing database and added a geometry column "the_geom" to "city_data" table with SRID and other essential details same as my shapefile.
Now I have a shapefile with city boundary as polygon and it also has city_id which is exactly same as PostgreSQL table.
I would like to load the polygon data from shapefile and insert/update into corresponding rows in PostGIS table based on city_id.
Is it possible to do directly or is there some workaround for doing this task?