Search Postgresql Archives

Re: Merge data from two databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Actually you have to write a program to insert one database into another. This is so the program
can check for concistancy and maybe recect records or datasets that are inconsistent.

GH

2010/5/28 Jamie Lawrence-Jenner <jamie.jenner@xxxxxxxxxxxxx>

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




--
gorhas@xxxxxxxxx
Mob: 070-5530148

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux