Merge data from two databases

Поиск
Список
Период
Сортировка
От Jamie Lawrence-Jenner
Тема Merge data from two databases
Дата
Msg-id !&!AAAAAAAAAAAYAAAAAAAAACSjyZCDEbJLs7GIuOJ8tGbCgAAAEAAAAOmk7F7hE25DgnyZ9s2PdBQBAAAAAA==@autovhc.co.uk
обсуждение исходный текст
Ответы Re: Merge data from two databases  (Goran Hasse <gorhas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: INSERTing lots of data
Следующее
От: Daniel Bausch
Дата:
Сообщение: Searching for paper about pg's optimizer cost model