I want to merge two layers which have identical structure.

First layer is from postgres database table say "layer1" and other layer is shapefile say "layer2". I want to merge layer2 "INTO" layer1 (NOT third layer).

I tried to copy paste in editing mode but it does not add attributes. any suggestions?

Note: the main layer is layer1 -postgresql database table.

attribute table

closed as unclear what you're asking by Andre Silva, Vince, John Powell, Mapperz Dec 29 '16 at 16:50

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Copying should bring in attributes if the column names are the same. I would double check your attributes actually have the same names. – HeikkiVesanto Aug 24 '15 at 10:15
  • 1
    You need to define "merge" here. Do you mean (1) you want to add the shapefile to the table layer1? Or, (2) that you want to update the table (perhaps by GID) with the results of the shapefile (newer or better data), or (3) a combination of both new entries and updates. Until this information is added, I vote to close the question. It's unclear what is being asked. There is no sample data. – Evan Carroll Dec 28 '16 at 19:59

You can try the merge tool wish merge a lot of shp to one

Merge tool

  • elmo yes i saw that but it gives third layer which i don't want . – Abhijit Gujar Aug 24 '15 at 10:15
  • also my main layer is Postgresql table which is not supported in merge tool. – Abhijit Gujar Aug 24 '15 at 10:27
  • can you perfom an attribute join using your gid column? – elmo Aug 24 '15 at 11:24

Not the answer you're looking for? Browse other questions tagged or ask your own question.