On Monday, July 8, 2024, intmail01 <
intmail01@gmail.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.