Postgres Pro
Downloads
Home   >   mailing lists

Re: Trick to create alias/mirror table - Mailing list pgsql-sql

From shammat@gmx.net
Subject Re: Trick to create alias/mirror table
Date
Msg-id f6cd047b-6f0b-4c3a-8cbf-c735ff1470d0@gmx.net
Whole thread Raw
In response to Re: Trick to create alias/mirror table  (intmail01 <intmail01@gmail.com>)
List pgsql-sql
Tree view 
intmail01 schrieb am 08.07.2024 um 15:04:
> 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.

You might want to look for "no code" or "low code" solutions to provide an end-user friendly GUI to edit the data.

Tools in that direction that I have came across, but have never tried are SQLPage, NocoDB or Budibase.

Using a tool like that might even remove the need to "shield" the actual tables through views.

pgsql-sql by date:

Previous
From: shammat@gmx.net
Date:
Subject: Re: Trick to create alias/mirror table
Next
From: Frank Komsic
Date:
Subject: SQL statements error in pgsql 16 but not in pgsql 12