two databases in one

[Soulabaille Samantha <samantha(dot)soulabaille(at)sihpic(dot)fr>]

Hello,

I'm working with a postgresql 7.4.7
I've got two databases with the same tables and schema on two different 
servers.
I want to have only one database.
So i would like to insert in the first database the data of the second 
database.
I don't know how to do this because almost of the tables contains serial.
It's for production databases, i can't make mistakes.

Can anyone help me? It's urgent.

Thanks




begin:vcard
fn:Samantha  Soulabaille
n:Soulabaille;Samantha 
org:SIHPIC
adr;dom:;;43 avenue d'Italie;amiens;;80094 cedex 3
email;internet:samantha(dot)soulabaille(at)sihpic(dot)fr
x-mozilla-html:FALSE
version:2.1
end:vcard