Re: Slick way to update multiple tables.

From: "Theodore M Rolle, Jr(dot)" <stercor(at)gmail(dot)com>
To: Michael Lewis <mlewis(at)entrata(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Slick way to update multiple tables.
Date: 2021-04-01 17:19:48
Message-ID: CAPDmd-DnZSu6o7uAPyqU-AM5gmni+yH9x7Ln1ANCxu0MBDACOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 1, 2021 at 12:43 PM Michael Lewis <mlewis(at)entrata(dot)com> wrote:

> You can have an updatable view.
>

*Show-stopper?*
The defining query of the view must have exactly one entry in the FROM clause,
which can be a table or another updatable view.

Or multiple VIEWs? I've never done VIEWs...

--
GnuPG/PGP key: 0xDD4276BA
+-----------------------------------------------------------------------------------------------------+
| 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510 |
| 58209 74944[59230 78164]06286 20899 86280
+----------------------------------|
| 34825 34211 70679*82148 08651 32823 06647 | May the spirit
|
| 09384 46095 50582 23172 53594 08128 48111 | of π spread
|
| 74502 84102 70193 85211 05559 64462 29489 | around the world.
|
| 54930 38196 44288 10975 66593 34461 28475 | PI VOBISCUM!
|
| 38196 44288 10975 66593 34461 28475 64823
+---------------------------------|
| 37867 83165 27120 19091 45648 56692 34603 48610 45432 6648... |
+----------------------------------------------------------------------------------------------------+

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Lewis 2021-04-01 17:27:37 Re: Slick way to update multiple tables.
Previous Message Michael Lewis 2021-04-01 16:42:51 Re: Slick way to update multiple tables.