Hello, MC. Only human can do this. Moreover, if "data integrity is very important".
Regards You wrote: MM> Hi, MM> I'm looking to migrate psql db1 to a psql db2 that has a different structure MM> even though 70% would be the same. I'd need a tool that allows me to map MM> field to field and then migrate the data from one db to another. Needless to MM> say that preserving data integrity is very important. MM> Any good idea what would be the best approach ? MM> Thanks, MM> Constantin MM> http://www.goodstockimages.com MM> ---------------------------(end of MM> broadcast)--------------------------- MM> TIP 4: Have you searched our list archives? MM> http://archives.postgresql.org -- With best wishes, Pavel mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings