[GTALUG] looking for a tool to transform table relationships
Steve Petrie, P.Eng.
apetrie at aspetrie.net
Sat Jul 21 06:55:13 EDT 2018
You could also consult the PostgreSQL users email forum pgsql-general at lists.postgresql.org
Needs registration, but when I was receiving the forum messages, I noticed that participants were always promptly helpful to all comers. But sometimes there is a LOT of email traffic.
I dropped out from this PosthreSQL forum a while ago, just because I chose another direction for my database application. Nothing wrong with PostgreSQL at all -- it's a great product.
Steve
----- Original Message -----
From: Alex Volkov via talk
To: GTALUG Talk
Sent: Friday, July 20, 2018 1:42 PM
Subject: [GTALUG] looking for a tool to transform table relationships
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.
---
Talk Mailing List
talk at gtalug.org
https://gtalug.org/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/talk/attachments/20180721/e085221c/attachment.html>
More information about the talk
mailing list