Re: merge 2 dumps

Joao Ferreira gmail wrote:
> hello all,
>
> I have 2 dumps of the same Pg database in diferent instants.
>
> I'dd like to merge the two dumps into one single dump in order to
> restore all data at one time.

Is there any overlap in the data?

If so, simplest might be to restore dump1, rename all the tables,
restore dump2 then run queries to rationalise your two sets of tables.

--
  Richard Huxton
  Archonet Ltd