Merge data from two databases - Mailing list pgsql-general

From Jamie Lawrence-Jenner
Subject Merge data from two databases
Date
Msg-id !&!AAAAAAAAAAAYAAAAAAAAACSjyZCDEbJLs7GIuOJ8tGbCgAAAEAAAAOmk7F7hE25DgnyZ9s2PdBQBAAAAAA==@autovhc.co.uk
Whole thread Raw
Responses Re: Merge data from two databases  (Goran Hasse <gorhas@gmail.com>)
List pgsql-general

Hi There

 

We have a stats databases which has been dumped out a few times over the last year.

 

What i would now like to do is to merge these dumps into one database. The problem is is that when the dumps were done, a drop and create was carried out on the database so primary key columns will collide

 

I have three dumpes, how do i merge the data into one database please

 

Many thanks

 

Jamie

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: INSERTing lots of data
Next
From: Daniel Bausch
Date:
Subject: Searching for paper about pg's optimizer cost model