I have to combine data from 4 different databases. Each having its own design.
What i want to do is to Create a new database with my desired schema. and one schema per (to be merged) database
Then export tables from all other databases and import this data into a unique corresponding schemas schema inside my final database.
How do i export table data from Postgresql Databases.
After having one database with multiple schemas i will use cross schema queries to read and write data to target schema.
Thanks in anticipation.