Postgres Pro
Downloads
Home   >   mailing lists

Re: Slick way to update multiple tables. - Mailing list pgsql-general

From Ron
Subject Re: Slick way to update multiple tables.
Date
Msg-id cfa99b67-50e1-47f7-a687-f1945c82f0a9@gmail.com
Whole thread Raw
In response to Slick way to update multiple tables.  ("Theodore M Rolle, Jr." <stercor@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Is replacing transactions with CTE a good idea?
Next
From: Dave Cramer
Date:
Subject: Re: Is replacing transactions with CTE a good idea?