Thread

1. Trick to create alias/mirror table

   intmail01 <intmail01@gmail.com> — 2024-07-08T11:27:37Z

   Hi,
   Looking for a trick to make something like an alias or a mirror table. The
   alias can be updated. View is not suitable because it is read only data.
   The alias is always linked to the original table. When a modification
   occurred in the original table this will be visible in all link tables.
   
   Thanks
   

2. Re: Trick to create alias/mirror table

   Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-08T11:55:37Z

   Hi
   
   You can use following options
   
   1. Postgres FDW
   2. Materialized Views
   
   
   Regards
   Kashif Zeeshan
   
   On Mon, Jul 8, 2024 at 4:25 PM intmail01 <intmail01@gmail.com> wrote:
   
   >
   >
   > Hi,
   > Looking for a trick to make something like an alias or a mirror table. The
   > alias can be updated. View is not suitable because it is read only data.
   > The alias is always linked to the original table. When a modification
   > occurred in the original table this will be visible in all link tables.
   >
   > Thanks
   >
   

3. Re: Trick to create alias/mirror table

   shammat@gmx.net — 2024-07-08T12:09:30Z

   intmail01 schrieb am 08.07.2024 um 13:27:
   > Hi, Looking for a trick to make something like an alias or a mirror
   > table. The alias can be updated. View is not suitable because it is
   > read only data. The alias is always linked to the original table.
   > When a modification occurred in the original table this will be
   > visible in all link tables.
   
   This sounds very much as if a view would solve that requirement.
   
   Views can be updated in Postgres. Either automatically if it's a "simple view"
   or by providing a function that handles the DML.
   
   
   
   
   

4. Re: Trick to create alias/mirror table

   Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com> — 2024-07-08T12:17:48Z

   On 7/8/24 14:27, intmail01 wrote:
   >
   > 	
   >
   > Hi,
   > Looking for a trick to make something like an alias or a mirror table. 
   > The alias can be updated.
   
   > View is not suitable because it is read only data.
   What? Check out the docs. Views can be perfectly modified.
   > The alias is always linked to the original table. When a modification 
   > occurred in the original table this will be visible in all link tables.
   >
   > Thanks

5. Re: Trick to create alias/mirror table

   intmail01 <intmail01@gmail.com> — 2024-07-08T13:04:55Z

   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.
   
   On Mon, Jul 8, 2024 at 3:09 PM <shammat@gmx.net> wrote:
   
   > intmail01 schrieb am 08.07.2024 um 13:27:
   > > Hi, Looking for a trick to make something like an alias or a mirror
   > > table. The alias can be updated. View is not suitable because it is
   > > read only data. The alias is always linked to the original table.
   > > When a modification occurred in the original table this will be
   > > visible in all link tables.
   >
   > This sounds very much as if a view would solve that requirement.
   >
   > Views can be updated in Postgres. Either automatically if it's a "simple
   > view"
   > or by providing a function that handles the DML.
   >
   >
   >
   >
   

6. Re: Trick to create alias/mirror table

   David G. Johnston <david.g.johnston@gmail.com> — 2024-07-08T13:11:44Z

   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.
   

7. Re: Trick to create alias/mirror table

   shammat@gmx.net — 2024-07-08T13:29:39Z

   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.
   
   
   Well, that's a bug in those applications and you should file a bug report or enhancment request with those tools.
   
   As a side note: I would never provide an "admin" tool like pgAdmin to end users that have no idea what "SQL" is.
   
   
   
   
   
   

8. Re: Trick to create alias/mirror table

   shammat@gmx.net — 2024-07-08T13:44:21Z

   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.