There are two databases:
DatabaseB with the same schema. These databases have millions of rows.
The plan is to convert them into one single database (
DatabaseCommon) and multiple schemas (
What is the best way to transfer data, indexes, etc. from the existing databases to
Is there a Postgres script that can handle this use-case?
We can have downtime. There will be around 20 databases. Users are restricted to their own schema.