Merge data from two databases

From: "Jamie Lawrence-Jenner" <jamie(dot)jenner(at)autovhc(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Merge data from two databases
Date: 2010-05-28 10:26:35
Message-ID: !&!AAAAAAAAAAAYAAAAAAAAACSjyZCDEbJLs7GIuOJ8tGbCgAAAEAAAAOmk7F7hE25DgnyZ9s2PdBQBAAAAAA==@autovhc.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dbarrett 2010-05-28 10:32:26 PostgreSQL DBA Opening
Previous Message Alban Hertroys 2010-05-28 10:22:15 Re: INSERTing lots of data