| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | intmail01 <intmail01(at)gmail(dot)com> |
| Cc: | "shammat(at)gmx(dot)net" <shammat(at)gmx(dot)net>, "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Trick to create alias/mirror table |
| Date: | 2024-07-08 13:11:44 |
| Message-ID: | CAKFQuwZYMs7DVbvWYE6ZZPM3+R0SAmGuqp9t_=wW64qkXU6p4Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Monday, July 8, 2024, intmail01 <intmail01(at)gmail(dot)com> wrote:
> No. Simple view can not be updated with a GUI like PgAdmin or LibreOffice
> Base. Only query code can modify it and every people can not code sql.
>
Fair. But updatable views are the solution PostgreSQL provides to your use
case. That client applications aren’t fully exposing it to the user is
unfortunate. There isn’t another way of doing this aside from having a
bunch of synchronized tables done probably with manual triggers.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shammat | 2024-07-08 13:29:39 | Re: Trick to create alias/mirror table |
| Previous Message | intmail01 | 2024-07-08 13:04:55 | Re: Trick to create alias/mirror table |