Re: Tools for moving normalized data around

From: Jeremy Smith <jeremy(at)musicsmith(dot)net>
To: Peter <pmc(at)citylink(dot)dinoex(dot)sub(dot)org>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Tools for moving normalized data around
Date: 2023-01-18 20:02:37
Message-ID: CAM8SmLXD5-4icuCdbjWTGPtxsWjwVU+cxptcLAsX8+CDtrZcdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
> How to do this with two tables connected via one foreign key, that is
> explained a dozen times in Stackoverflow. But what if the tree is 50
> tables and 120 foreign key columns?
> It can be done. But probably not manually.
>
> So, as this seems a very usual use-case for normalized data, is there
> any tooling available? Anywhere? (I searched, I didn't find.)
>
>
I haven't used it, but this seems like the problem that Jailer is trying to
solve: https://github.com/Wisser/Jailer

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-01-18 20:03:38 Re: minor bug
Previous Message Peter 2023-01-18 19:47:03 Tools for moving normalized data around