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.