[GTALUG] looking for a tool to transform table relationships

[Alex Volkov]

Hey Everyone,

I'm looking for a tool to transform (possibly migrate) data from one 
postgres db to another.

I have two postgres databases -- old (not normalized) has all the data 
and new (normalized with some major schema changes) has no data.

The new db has more tables and table relationship structured 
differently, some data residing in old db is in text column in csv 
format, whereas in new database it's a separate table, and so on.

I've been thinking of writing a script that would just transform data 
from one format to the other, but before writing a bunch of code that's 
going to be run exactly once, I'm wondering if there a tool out there 
which I can use to express one-way transformation rules for these databases.


Thanks,


Alex.