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
This is an open-ended question, where 5 peoples will give you 7 answers.
I would say,
- extract old data
- see what you have to do to reformat/trim/merge them into new
structure. You said, data structure is different, not just data
format.
- insert new data
But, you alread
Hey Chris,
Thank you for your reply, this is the way to do this task properly. In
my case I don't need to clean any data, it already comes validated from
the db, so I might get away with using dblink and some functions, if
that fails, I'll do dump/restore into temporary tables.
So far I figu
| From: Alex Volkov via talk
| On 2018-07-20 03:35 PM, D. Hugh Redelmeier via talk wrote:
| > Super naive question:
I should disclose just how naive. I've essentially never used SQL.
OK, perhaps a query or two when puzzled by MythTV.
| > Could you not do this transformation in SQL?
|
| Yes,
On Fri, 20 Jul 2018 at 13:42, Alex Volkov via talk wrote:
>
> 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 cha
On Fri, Jul 20, 2018 at 3:40 PM Alex Volkov via talk
wrote:
> Yes, now as I've done a bit more research just doing SQL with dblink
> might be the way to go. The thing I don't like is SQL for text
> transformation can be pretty awkward.
>
PostgreSQL has great text manipulation functions actually.
Yes, now as I've done a bit more research just doing SQL with dblink
might be the way to go. The thing I don't like is SQL for text
transformation can be pretty awkward.
On 2018-07-20 03:35 PM, D. Hugh Redelmeier via talk wrote:
| From: Alex Volkov via talk
| I'm looking for a tool to transf
| From: Alex Volkov via talk
| I'm looking for a tool to transform (possibly migrate) data from one postgres
| db to another.
Super naive question:
Could you not do this transformation in SQL?
---
Talk Mailing List
talk@gtalug.org
https://gtalug.org/mailman/listinfo/talk
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 relationshi