Re: Trick to create alias/mirror table

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(at)gmx(dot)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.
>
>
>
>