On Tue, 2008-11-11 at 11:16 +0000, Richard Huxton wrote: > 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?
no. I don't expect that there might be overlaps. any simpler solution in this case ? could I just get the "COPY TO" sections from the files and load them one after the other ? I never tried this before... j > > If so, simplest might be to restore dump1, rename all the tables, > restore dump2 then run queries to rationalise your two sets of tables. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
