Timeline for Merging multiple databases as separate schemas in PostgreSQL
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 23, 2017 at 23:23 | comment | added | xzilla | The most likely scenario is that the 4 separate databases all make use of the public schema, and so you will need to modify the schema names before loading them into the new database. If by chance they all use unique schema names inside the source databases, then your right, no edit will be neccessary. But it seems likely the edit would be needed. | |
| Dec 16, 2012 at 14:03 | history | edited | András Váczi | CC BY-SA 3.0 |
adding meat to the theory
|
| Dec 16, 2012 at 13:43 | history | migrated | from stackoverflow.com (revisions) | ||
| Dec 12, 2012 at 23:36 | comment | added | Wojtas |
I think editing isn't necessary. To dump schemas from databases use pg_dump with -n option and restore them into desired database. If you want large objects to be included in the dump take a look at -b option.
|
|
| Dec 12, 2012 at 15:50 | history | answered | martin | CC BY-SA 3.0 |