OH, I think I understand: You want to copy and paste from a shapefile layer into the appropriate postgis layer?
I don't know if you can do that directly. You may want to write a script to do it, or import the shapefile into a temporary table and then using multiple sql statements to build up your normalized tables. http://stackoverflow.com/questions/1310103/split-table-with-duplicates-into-2-normalized-tables has a little example. Basically you import the towns with a insert into blah select distinct (town code, town description) and then continue that, but for the foreign keys have your updates or inserts do a subquery to find the correct foreign row. Jim On 04/18/2015 02:01 PM, Luciano wrote: > Ok, > > I have a shape file with the following structure. > > Shape file, columns: > town code; > town description; > Neighborhood code; > name of the neighborhood; > block code; > Street code; > street name; > > Using the How to Copy / paste a geometry fromshape file to postgiswith > follow structure: > > Cities table (data): > - Town id > - Description of town > > Neighborhoods table (data): > - Id of the neighborhood > - Description of the neighborhood > - Id of town (foreign key) > > Blocks table: > - Id of the court > - Block of code > - Town id (foreign key) > - Geometry, polygon > > Streets table: > - Street id > - Street name > - Town id (foreign key) > - Geometry, line > > > > 2015-04-18 13:36 GMT-03:00 Rémi Cura <remi.c...@gmail.com > <mailto:remi.c...@gmail.com>>: > > maintaining your data model is easy to do with triggers. > > About copy / past. > Sorry this just doesn't make much sense to me. > > You can import shapefile into postgres if it is the question. > You can also use trigger on the import table to fill you rmodel with > the imported data. > > Cheers, > Rémi-C > > 2015-04-18 17:39 GMT+02:00 Luciano <br.analista...@gmail.com > <mailto:br.analista...@gmail.com>>: > > > Hi, > I wonder how can I update a postgresql postgis database before > the following scenario: > Always worked with shape files and update them used copy / paste > between files. > Now, think about creating a database in PostgreSQL and would > like to continue using copy / paste to update polygons, but in > my database structure is different from the shape file. For example: > Imagine that the shapefile have all the fields in one table, > already in the database, by reason of standardization, have > these columns in tables > distinct. Below is an example of a register of towns. > > File shape, columns: > town code; > town description; > Neighborhood code; > name of the neighborhood; > block code; > Street code; > street name; > > In Postgres / Gis could look like this: > > Cities table (data): > - Town id > - Description of town > > Neighborhoods table (data): > - Id of the neighborhood > - Description of the neighborhood > - Id of town (foreign key) > > Blocks table: > - Id of the court > - Block of code > - Town id (foreign key) > - Geometry, polygon > > Streets table: > - Street id > - Street name > - Town id (foreign key) > - Geometry, line > > How could update (insert) a block in postgresql table using copy > / paste the shape file? > Would have to create a trigger/procedure (instead of) to > automate the process? > Fields of shape file should be equal to the fields of database > table? > Some practical example as a reference? > > tia > -- > Luciano > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > > > -- > Luciano > > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
signature.asc
Description: OpenPGP digital signature
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users