I have a spatial postgis database named "testdata" having two schema named "afgdata" and "pakdata" with common table names viz. building_a, places, railways, roads, water_a, waterways of different area.
I am not familiar with both Postgis and FME.
I want to merge both schema in to new schema named "mergedata" within same database. Can anybody help me out to do it with FME or direct in PostgreSQL?
Is it possible to merge both schema and output in new database in public schema?