Re: [External] Merging two database dumps

2018-06-13 Thread pavan95
Yes Vijay, It might work, but I'm thinking it will be a performance overhead in case of complex data. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: [External] Merging two database dumps

2018-06-13 Thread Vijaykumar Jain
You can try one option, although just a thought in the air 😊 Use postgres FDW ex. https://robots.thoughtbot.com/postgres-foreign-data-wrapper Create foreign tables in the relevant server schema And then union/union all 😊 or your custom constraint on the destination table where you dump the ro