Re: Slick way to update multiple tables.

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Slick way to update multiple tables.
Date: 2021-04-04 02:10:08
Message-ID: cfa99b67-50e1-47f7-a687-f1945c82f0a9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/1/21 11:16 AM, Theodore M Rolle, Jr. wrote:
> I SELECT items from three tables.
>
> It seems that the only way to put updated fields into their proper table
> is to query /each/ field, then UPDATE /each/ table.
>
> Am I missing something here?
> Is there a way to do this automatically?
>

Did you join the three tables when querying?

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2021-04-04 12:35:41 Re: Is replacing transactions with CTE a good idea?
Previous Message Ron 2021-04-04 02:06:31 Re: Is replacing transactions with CTE a good idea?