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.