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

From intmail01
Subject Re: Trick to create alias/mirror table
Date
Msg-id CAKJANSCZa_q7SpAwmN1K1vbFcQd5+u0L8JZ5+fA16ucG7iv6kw@mail.gmail.com
Whole thread Raw
In response to Re: Trick to create alias/mirror table  (shammat@gmx.net)
Responses Re: Trick to create alias/mirror table
Re: Trick to create alias/mirror table
Re: Trick to create alias/mirror table
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: Achilleas Mantzios - cloud
Date:
Subject: Re: Trick to create alias/mirror table
Next
From: "David G. Johnston"
Date:
Subject: Re: Trick to create alias/mirror table